GETS, PINS and RELOADS in v$librarycache.

From: Tony Adolph <t_adolph_at_hotmail.com>
Date: Fri, 22 Apr 2005 10:44:25 +0200
Message-ID: <BAY103-F121888273913C9FE3D1425FA2D0@phx.gbl>

Hi all,

I am trying to understand GETS, PINS and RELOADS in v$librarycache.

I have been reading the oracle documentation and am still not 100%. I read an AskTom thread and at the end was just as unsure as at the start. He seemed to
just repeat the oracle definition rather than actually explain the definition.

NAMESPACE GETS GETHITS PINS PINHITS RELOADS

---

SQL AREA        4164     3964  13839    13487       14
TABLE/PROCEDURE	5762     4826   3218     1804        0
BODY              21       15     20       13        0
TRIGGER            7        2      7        2        0
INDEX             32        0     32        0        0

(reads ok in courier)

GETS: the number of times there was a lookup for the definition of an object, eg. a table definition lookup. GETHITS: sum(It was there).

PINS: the number of times that a query already existed in cache and will now be executed, eg. an sql statement and its parse plan lookup and execution.
PINHITS: sum(It was there).

RELOADS: a found execution plan referenced an object whose cached definition has been invalidated so must be reloaded.

Is this close to the mark?

Please reply in non-strainght-of-the-manual terms please as they aren't sinking in!

Thanks
Tony

---

Don't just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/

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

Received on Fri Apr 22 2005 - 04:48:36 CDT