Oracle Database 10g DBA Performance & Tuning
Course
In London
Description
-
Type
Course
-
Location
London
-
Duration
3 Days
Delegates will be introduced to the main concepts of Oracle performance tuning and will gain practical experience in analyzing and tuning database performance. They will learn to identify tuning contentions and be able to take corrective action.
Facilities
Location
Start date
Start date
Reviews
Course programme
- Tuning goals and methodology
- Common tuning problems
- Log a SR with Oracle support
- Statistics and wait events
- Metrics, alerts and baselines
- Statspack
- Automatic Workload Repository
- Tune theSGAand Shared Pool
- Tune the data block buffers
- Automatic Shared Memory Management
- PGAand temporary space
- Checkpoint and redo log tuning
- Manage disk I/O
- Manage undo information
- Tune block space
- Initial database configuration
- Materialized views
- ParallelDML
Oracle Database 10g DBA Performance & Tuning