-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|