|
Provided by: Serebra Learning Corporation Oracle Database 10g Performance Tuning Instance Tuning |
 |
Training
Provided by Serebra Learning Corporation
This course covers the concepts related to tuning the shared pool and the buffer cache. This course also covers the concepts related to the System Global Area (SGA), Automatic Shared Memory Management (ASMM), the Program Global Area (PGA), and the PGA Target Advice. This course is designed for DBAs, database architects, support engineers, and technical consultants.
|
|
||||||||
Oracle Database 10g Performance Tuning Instance Tuning
Audience
This course is designed for DBAs, database architects, support engineers, and technical consultants.
Topics
- Unit 1: Shared Pool
- Identify the components of the shared pool architecture.
- Identify the features of Mutex.
- Identify diagnostic tools for shared pool tuning.
- Identify key concepts related to library cache activity.
- Identify key concepts related to sizing the shared pool.
- Identify key concepts related to memory requirements of the shared pool.
- Identify key concepts related to tuning the data dictionary cache.
- Identify key concepts related to tuning the user global area (UGA). Unit 2: Buffer Cache
- Identify the features of buffer cache.
- Identify different techniques to tune buffer cache.
- Identify the symptoms of buffer cache problems involving latches.
- Identify key concepts related to symptoms of buffer cache problems involving waits.
- Identify key concepts related to the solutions for the buffer cache size problems.
- Identify the solutions to the buffer cache problems involving cache objects.
Objectives
- Learn To
- Identify key concepts related to the shared pool.
- Identify the features, techniques, and problems related with the buffer cache.
- Identify key concepts related to the System Global Area (SGA) components and Automatic Shared Memory Management (ASMM).
- Identify key concepts related to tuning the Program Global Area (PGA).
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
