Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Understanding Gets, Pins and Reloads - V$librarycache

Understanding Gets, Pins and Reloads - V$librarycache

From: Thotangare, Ajay \(GTI\) <Ajay_Thotangare_at_ml.com>
Date: Wed, 9 May 2007 14:54:52 -0400
Message-ID: <C8C1CE9973039245BF52C0FC3DF02F60C5C854@MLNYA222MB.amrs.win.ml.com>


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/


--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 09 2007 - 13:54:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US