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

  • From: "Don Seiler" <don@xxxxxxxxx>
  • To: Ajay_Thotangare@xxxxxx
  • Date: Wed, 9 May 2007 15:05:13 -0500

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@xxxxxx> 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
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2007