Hi,

Can somebody help me to check if I'm understanding the V$LibraryCache
Correctly or not.

Parse Phase
Gets No of time any Object was requested
GetHits No. of time the parsed information of the requested Object was
found cached in Library

Execution Phase
Pins No. of times the requested Object was Executed successfully
PinHits No. of times the requested Object which was found parsed in
Library was Executed


Order of the above columns w.r.t Value will be:
Maximum in Gets
Then in Pins
Then in GetHits
Then in PinHits

GetHitRatio = GetHits/Gets
Should be near to 1 so that for a Object Request most of the time
Parsed Information of the Object is found in Library

PinHitRatio = GetHits/Pins
Should be Near to 1 so that Object Excutions are mostly done using
the Parsed information in Library

GetHitRatio will always be greater than PinHitRatio


Regards
SK Mittal
Oracle LazyDBA home page