 |
|
Diving
Into the Shared Pool - An In Depth Look at Tuning the Shared Pool (Part 2)
Oracle Tips by Mike Ault |
Monitoring Library and Data
Dictionary Caches
Date:
11/21/98 Page: 1
Time: 02:51 PM
Library Caches Report SYSTEM
ORTEST1 database
Library Object Gets
Get Hit% Pins Pin Hit% Reloads Invalid
--------------- ----------
-------- ---------- -------- ------- -------
SQL AREA 46,044
99.17 99,139 99.36 24 16
TABLE/PROCEDURE 1,824
84.59 6,935 93.21 3 0
BODY 166
93.98 171 91.23 0 0
TRIGGER 0
100.00 0 100.00 0 0
INDEX
27 .00 27 .00 0 0
CLUSTER 373
98.12 373 97.59 0 0
OBJECT 0
100.00 0 100.00 0 0
PIPE 0
100.00 0 100.00 0 0
Figure 10: Example Of The Output From Library Caches Report
The data dictionary caches used to be individually tunable through
several initialization parameters, now they are internally
controlled. The script in Figure 11 should be used to monitor the
overall hit ratio for the data dictionary caches.
rem
rem title: ddcache.sql
rem FUNCTION: report on the
v$rowcache table
rem HISTORY: created sept
1995 MRA
rem
start title80 "DD Cache Hit
Ratio"
spool rep_out\&db\ddcache
SELECT (SUM(getmisses)/SUM(gets))
RATIO
FROM V$ROWCACHE
/
spool off
pause Press enter to continue
ttitle off
Figure 11: Script to Monitor the Data Dictionary Caches
 |
For more information on this topic, I recommend Don
Burleson's latest book "Oracle
Tuning: The Definitive Reference".
You can buy it direct from the publisher for 50%-off and get
instant access to the code depot of Oracle tuning scripts: |
http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm
 |
Expert Remote DBA
BC is America's oldest and largest Remote DBA Oracle support
provider. Get real Remote DBA experts, call
BC Remote DBA today. |
 |
|
