Understanding Gets, Pins and Reloads - V$librarycache
- From: "Thotangare, Ajay \(GTI\)" <Ajay_Thotangare@xxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 9 May 2007 14:54:52 -0400
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/
--------------------------------------------------------
Other related posts:
