From 123-CBT Computer Based Training
Oracle9i Database Admin Manage an Instance 

... Learn To Identify the memory structures of the
SGA and the information stored in the database and nondatabase files. Identify the connection procedures and the processes generated during database connection. Identify the stages in processing a query and the memory structures used in query processing. Identify the steps of
DML processing and the memory
more...
Oracle8i Performance Tuning Managing Memory Disk I O 

...oals for tuning the library cache. View the sizes of all
SGA structures by using the V$SGASTAT view. Determine the percentage of parse calls that find a cursor to share by using the
GETHITRATIO column of the V$LIBRARYCACHE view. Determine the reloads-to-pins ratio by using the V$LIBRARYCACHE view. Compute the amount of sharable memory that has been used by using the V$SQLAREA view. Keep a
more...
Oracle8i Database Admin Manage an Instance 

.... 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 combinations
more...
Oracle8 Database Administration - Manage an Instance 

....
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 combinations
more...