gethitratio vs pinhitratio
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: gethitratio vs pinhitratio

  1. #1
    Join Date
    Oct 2002
    Location
    India
    Posts
    42

    gethitratio vs pinhitratio

    Hi friends

    I am not able to understand the difference between gethitratio and pinhitratio attributes of the v$librarycache view clearly. can somebody define the two.

    Thanks
    Burzin

  2. #2
    Join Date
    Oct 2002
    Location
    Singapore
    Posts
    49
    gethitratio is related to the parse phase of the SQL statement issued by application which found the parsed copy in memory. the GETHIT column in the v$librarycache stores the no. of time the SQL statment issue by application is found.
    (recommend OTLP > 95%)

    pinhitratio is related to the excution phase. The PINS column in v$librarycache is incremented each time the statment found in memory is excuted. This ratio indicate how freq executed statements found associated parsed SQL statement alreday in library cache.
    ( recommned OLTP > 90%)
    Regards
    CF

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