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

   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