|
Sample Text:
Oracle library cache scripts
The following STATSPACK script
will compute the library cache miss ratio. Note that the script
sums all of the values for the individual components within the
library cache and provides an instance-wide view of the health
of the library cache.
See code depot for full scripts
set lines 80;
set pages 999;
. . .
select
. . .
from
stats$librarycache old,
stats$librarycache new,
stats$snapshot sn
where
. . .
;
Here is the output. This report
can easily be customized to alert the DBA when there are
excessive executions or library cache misses.
Cache Misses Library Cache
Yr. Mo Dy Hr. execs While Executing Miss Ratio
---------------- ---------- ---------------
-----------------------
2001-12-11
10 10,338
3 .00029
2001-12-12 10
182,477 134 .00073
2001-12-14 10
190,707 202 .00106
2001-12-16 10
2,803 11 .00392
Once this report identifies a
time period where there may be a problem, STATSPACK provides the
ability to run detailed reports to show the behavior of the
objects within the library cache. In the preceding example, you
see a clear RAM shortage in the shared pool between 10:00 A.M.
and 11:00 A.M. each day. In this case, you could dynamically
reconfigure the shared pool with additional RAM memory from the
db_cache_size during this period.
Order now from the
publisher and get 40% off the retail price!
You also receive immediate online access to the
code depot!
Only $9.95
Buy it Now!
|
|
