This course is aimed at the DBA's who often have to make the first attempt at solving performance problems prior to, and as they develop. We cover all aspects of internal database tuning on an Oracle 10g platform in this three-day course.
Training Course Objectives:
Everyone involved with the Oracle system; system architects, designers, developers and database administrators (DBA's), should consider performance tuning while carrying out their work.
This course is aimed at the DBA's who often have to make the first attempt at solving performance problems prior to, and as they develop. We cover all aspects of internal database tuning on an Oracle 10g platform in this three-day course.
The enhancements and changes that have been introduced in 10g will be discussed during this course for the benefit of DBA's responsible for earlier RDBMS versions for the purposes of planning and upgrade tuning.
FAQ Training Course Contents: Tuning Overview
Tuning Questions/Goals/Steps
Alerts, Trace Files & Events
Diagnostic Information
The Alert Log File
User Trace Files
Statistics Event Views
Dynamic Performance Views
Dynamic Performance Views
Collecting System-Wide Statistics
Collecting Session Related Statistics
Statspack
Oracle Wait Events
I/O related events
Lock related events
Latency related events
Gathering wait event data
Automatic Workload Repository
Automated snapshot collection
Active Session History
Automatic Database Diagnostics
Enterprise Manager Advisors
ADDM reports
Time model statistics
Wait model statistics
Tuning the Shared Pool
The Shared Global Area
Tuning the Library Cache
The Data Dictionary Cache
User Global Area and Shared Server
Tuning the Buffer Cache
Evaluating the Cache Hit Ratio
Adding Buffers
Using Multiple Buffer Pools
Defining Multiple Buffer Pools
Caching Tables
Tuning The Redo Log Buffer
Sizing The Redo Log Buffer
Reducing Redo Operations
SQL Tuning
Optimizer Modes
Diagnostic Tools
V$SQL_PLAN
Monitoring table and index useage
DBMS_STATS
Gathering statistics
Changing the data dictionary statistics
Automating statistics collection
Optimiser Plan Stability
Creating stored outlines
Using stored outlines
Viewing the execution paths
The OUTLN user
Materialised Views
Creating
Registering existing summary tables
Refresh options
Database Config. & I/O Issues
Tablespace Usage
Partitioning Tables and Indexes
Distributing Files Across Devices
Tuning Checkpoints
Automatic Storage Management
Oracle Blocks Efficiency
Database Storage Hierarchy
Database Block Size
Multiple Block Sizes
PCTFREE and PCTUSED
Automaic Space Segment Management
Detecting Chaining
Monitoring and Rebuilding Indexes
Tuning Rollback Segments
Rollback Segment Usage
Tools for Tuning Rollback Segments
Using Less Rollback
Using Automatic Undo Management
Tuning the Operating System
CPU Tuning Guidelines
Tuning Memory
Tuning I/O
Optimizing Sorts
Sort Area and Parameters
Tuning Sorts
Avoiding Sorts
Configuring Temporary Tablespaces
Database Default Temporary Tablespace
Automatic PGA Management
Tuning Different Applications
Comparing B-Tree and Bitmap Indexes
Creating Reverse Key Indexes
Index-Organized Tables
Clusters / Cluster Types
Histograms
Database Resource Manager
Creating Consumer groups and adding users
Allocating resources to groups
Activating resource plans
Lock Contention
Locking Mechanisms
Tools for Monitoring Locking Activity
Resolving Contention
Deadlocks
Contention Issues
Diagnosing Latch Problems
Resolving Latch contention
Diagnosing Free List Contention
Resolving Free List Contention
Founded in 2006 with headquarters in Glasgow, Elite Training offers a comprehensive range of IT, Professional Best Practice and Business Skills training across the UK.
At Elite Training, we understand that every client is different and as such customise training solutions to suit your individual requirements. We are interested in building strong, long lasting business relationships based on high quality training and customer care. We pride ourselves on responding quickly to queries and providing advice on all your training requirements.
Our experienced Account Managers work closely with our clients to deliver a range of solutions based on budgets, timelines and individual requirements. Whether you require one-to-one or group sessions, public or closed company training, we ensure you receive an individually tailored training service.
The candidates of this course must undertake a database project to become an Oracle Database SQL Certified Associate.
The Java SE 8 Oracle Certified Associate (OCA) certification will help you develop a strong understanding of the Java programming language.
Help protect your organization by using the knowledge gained in this course to correctly manage business databases. With this training, you learn the essential skills for administering SQL Server databases, and gain extensive experience using SQL Server tools to perform real-world administrative ta...
This course will teach the students what is Cosmos DB and how you can migrate MongoDB and Cassandra workloads to Cosmos DB.
The Oracle Database 19c Essential Administration course is designed for Database Administrators of small sized databases who need to carry out basic system administration tasks on Oracle Database 19c database.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy