Oracle 10g Database Tuning
Course
Inhouse
Description
-
Type
Course
-
Methodology
Inhouse
-
Duration
3 Days
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. Suitable for: Oracle Database Administrators. Oracle Systems Engineers. Oracle Support Engineers.
About this course
Oracle 10g SQL (O011) . 10g DBA Fundamentals I (O1010) . 10g DBA Fundamentals II (O1020) .
Reviews
Subjects
- Oracle 10g
Course programme
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
- Diagnostic Information
- The Alert Log File
- User Trace Files
- Statistics Event Views
- Dynamic Performance Views
- Collecting System-Wide Statistics
- Collecting Session Related Statistics
- Statspack
- I/O related events
- Lock related events
- Latency related events
- Gathering wait event data
- Automated snapshot collection
- Active Session History
- Enterprise Manager Advisors
- ADDM reports
- Time model statistics
- Wait model statistics
- The Shared Global Area
- Tuning the Library Cache
- The Data Dictionary Cache
- User Global Area and Shared Server
- Evaluating the Cache Hit Ratio
- Adding Buffers
- Using Multiple Buffer Pools
- Defining Multiple Buffer Pools
- Caching Tables
- Sizing The Redo Log Buffer
- Reducing Redo Operations
- Optimizer Modes
- Diagnostic Tools
- V$SQL_PLAN
- Monitoring table and index useage
- Gathering statistics
- Changing the data dictionary statistics
- Automating statistics collection
- Creating stored outlines
- Using stored outlines
- Viewing the execution paths
- The OUTLN user
- Creating
- Registering existing summary tables
- Refresh options
- Tablespace Usage
- Partitioning Tables and Indexes
- Distributing Files Across Devices
- Tuning Checkpoints
- Automatic Storage Management
- Database Storage Hierarchy
- Database Block Size
- Multiple Block Sizes
- PCTFREE and PCTUSED
- Automaic Space Segment Management
- Detecting Chaining
- Monitoring and Rebuilding Indexes
- Rollback Segment Usage
- Tools for Tuning Rollback Segments
- Using Less Rollback
- Using Automatic Undo Management
- CPU Tuning Guidelines
- Tuning Memory
- Tuning I/O
- Sort Area and Parameters
- Tuning Sorts
- Avoiding Sorts
- Configuring Temporary Tablespaces
- Database Default Temporary Tablespace
- Automatic PGA Management
- Comparing B-Tree and Bitmap Indexes
- Creating Reverse Key Indexes
- Index-Organized Tables
- Clusters / Cluster Types
- Histograms
- Creating Consumer groups and adding users
- Allocating resources to groups
- Activating resource plans
- Locking Mechanisms
- Tools for Monitoring Locking Activity
- Resolving Contention
- Deadlocks
- Diagnosing Latch Problems
- Resolving Latch contention
- Diagnosing Free List Contention
- Resolving Free List Contention
Oracle 10g Database Tuning