Online Pga eLearning Training
From Serebra Learning Corporation
Oracle Database 10g Performance Tuning Instance Tuning
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.
more...
From 123-CBT Computer Based Training
Oracle8i Database Admin Manage an Instance

...er cache. Match the contents of the Program Global Area (PGA) with their uses. Identify the steps in the execute phase of a given DML statement. Identify the uses of a rollback segment. Identify the characteristics of a redo log buffer. Identify the events that cause the Database Writer (DBWR) to write to data files. Identify the events that cause the Log Writer (LGWR) to write to the
more...
Oracle8 Database Administration - Manage an Instance

...er cache.
Match the contents of the Program Global Area (PGA) with their uses.
Identify the steps in the execute phase of a given DML statement.
Identify the uses of a rollback segment.
Identify the characteristics of a redo log buffer.
Identify the events that cause the Database Writer (DBWR) to write to datafiles.
Identify the events that cause the Log Writer (LGWR) to write to the redo
more...
Oracle 9i New Features Database Administration

... Identify the characteristics of the PGA memory management feature. Identify the new data dictionary enhancements that support the new memory management features. Identify the benefits of the dynamic SGA feature. Identify the characteristics of the dynamic SGA components. Match the
more...
