Re: Oracle Library Cache

My first thought would be, why were you compelled to look at that section of the AWR report? Do you have a performance problem? If so, what performance indicators pointed you in the direction of library cache hit ratios?

In general, looking at hit ratios in isolation is probably not a valid tuning strategy.

And no, I must admit, I don¹t know what ŒSQL AREA STATS¹ or ŒSQL AREA BUILD¹ means, in this context.

-Mark

On 10/23/13, 2:32 PM, "mvshelton_at_chartermi.net" <mvshelton_at_chartermi.net> wrote:

>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
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l