Oracle Library Cache
From: <mvshelton_at_chartermi.net>
Date: Wed, 23 Oct 2013 14:32:53 -0400 (EDT)
Message-ID: <697034f1.a26f0.141e6973d93.Webtop.48_at_chartermi.net>
SQL> select namespace,gets,gethits,round(gethitratio,2) gethitratio
Date: Wed, 23 Oct 2013 14:32:53 -0400 (EDT)
Message-ID: <697034f1.a26f0.141e6973d93.Webtop.48_at_chartermi.net>
SQL> select namespace,gets,gethits,round(gethitratio,2) gethitratio
2 from V$LIBRARYCACHE
3 where namespace like 'SQL%';
NAMESPACE
GETS
GETHITS GETHITRATIO
---------- -----------
SQL AREA
13927433
13762659 .99
SQL AREA STATS
201188
27167 .14
SQL AREA BUILD
265640
109679 .41
I noticed in my AWR report that a database had high pct misses for SQL AREA STATS of 87.56% and SQL AREA BUILD of 37% but I could not find any information that describes these library cache waits. I can query from v$library cache and get the hit ratio but I am not sure what this stat is. Any help would be appreciated.
Thanks, Matt
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 23 2013 - 20:32:53 CEST