Understanding the V$LibraryCache
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Understanding the V$LibraryCache

  1. #1
    Join Date
    Nov 2000
    New Delhi, India

    Understanding the V$LibraryCache


    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

    SK Mittal
    Last edited by ShrutiM; 06-27-2003 at 05:55 AM.

  2. #2
    Join Date
    Nov 2000
    New Delhi, India
    Any takers for this query Please.

    S K Mittal

  3. #3
    Join Date
    Jun 2000
    Madrid, Spain

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width