Re: Understanding Gets, Pins and Reloads - V$librarycache

See the Database Performance Tuning Guide on the shared pool:

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14211/memory.htm#i52830

Does a pretty good job of describing V$LIBRARYCACHE and how to use the info within.

Don.

On 5/9/07, Thotangare, Ajay (GTI) <Ajay_Thotangare_at_ml.com> wrote:
>
>
>
>
>
> Can someone please explain in detail the gets, pins and reloads in
> v$librarycache.
>
> How are these columns related to each other? When would gets, pins and
> reloads increase?
>
>
>
> I read some definitions like
>
> The GETS column indicates the number of times, since database instance
> startup, that the
>
> System requests handles to library objects in this namespace.
>
>
>
> The PINS column indicates the number of times, since database instance
> startup, that the
>
> System issues pin requests in order to access objects in the cache.
>
>
>
> Will both not go 1:1 ratio?
>
>
>
>
>
>
> ________________________________
>
> If you are not an intended recipient of this e-mail, please notify the
> sender, delete it and do not read, act upon, print, disclose, copy, retain
> or redistribute it. Click here for important additional terms relating to
> this e-mail. http://www.ml.com/email_terms/
> ________________________________
>

-- 
Don Seiler
oracle blog: http://ora.seiler.us
ultimate: http://www.mufc.us
--
http://www.freelists.org/webpage/oracle-l