Online Gethitratio eLearning Training
 online course |
 instructor led class |
 learn at home |
 group study |
 self directed training |
 cd based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer based learning |
 discount pricing |
 online tutorial |
From 123-CBT Computer Based Training
Oracle8i Performance Tuning Managing Memory Disk I O
...e 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 large object in memory by using the KEEP procedure of the DBMS_SHARED_POOL package. View the reserved pool space within the
more...
...e 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 large object in memory by using the KEEP procedure of the DBMS_SHARED_POOL package. View the reserved pool space within the
more...
Oracle8 Performance Tuning Managing Memory and Disk I O
...rcentage 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.
Identify the steps used to size the Library Cache.
Perform the steps to compute the amount of sharable memory that has been used using SELECT SUM query.
Perform the steps to keep large objects using the
more...
...rcentage 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.
Identify the steps used to size the Library Cache.
Perform the steps to compute the amount of sharable memory that has been used using SELECT SUM query.
Perform the steps to keep large objects using the
more...
