Online Global Area eLearning

Oracle Database 11g Tuning PGA Temporary Space AMM ...aging memory and temporary tablespaces. Automatic Program Global Area (PGA) memory management adapts the SQL memory allocation based on PGA memory available, SQL operator needs, and system workload. A temporary tablespace is used to store transient data generated explicitly by the user and implicitly by the system. This course explains how to diagnose PGA memory and temporary tablespace issues  more...

Oracle8 Database Administration - Manage an Instance ...rver process. Match the memory structures of the System Global Area (SGA) with the information stored by them. Match the mandatory background processes with their functions. Match the different types of files existing in a database with the information stored in them. Match the non-database files with the information stored in them. Sequence the stages in processing a query.  more...

Oracle8 Performance Tuning Managing Memory and Disk I O ...ata Dictionary Cache. Identify the function of the User Global Area. Match the diagnostic views of the Library Cache with their respective definitions. Perform the steps to determine the percentage of parse calls that find a cursor to share using GETHITRATIO column of the V$LIBRARYCACHE view Perform the steps to determine the reloads-to-pins ratio from the V$LIBRARYCACHE view.  more...

Oracle8i Performance Tuning Managing Memory Disk I O ...he amount of space used for a test connection in the user global area. Match the columns found in the V$ROWCACHE view with their definitions. Find the ratio of GETSMISSES to GETS from the V$ROWCACHE view. Select the features of configuring the large pool as a separate memory area. Determine the size of the free memory allocated to the large pool. Determine why the server could not allocate  more...

Oracle8i Database Admin Manage an Instance ...erver process. Match the memory structures of the System Global Area (SGA) with the information stored by them. Match the mandatory background processes with their functions. Match the different types of files existing in a database with the information stored in them. Match the non-database files with the information stored in them. Sequence the stages in processing a query. Identify the  more...