Low Pin Hit Ratio
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Low Pin Hit Ratio

  1. #1
    Join Date
    Sep 2000
    Posts
    362
    Hi,
    After querying the v$library cache table for the various ratios I found that my pin hit ration is very less for triggers and indexes. What should I d to fix this and what effects will it have if I just ignore it.


    select namespace, gets, gethits,
    2 gethitratio, pins, pinhitratio
    3 from v$librarycache ;

    GET HIT PIN HIT
    NAME GETS GETHITS RATIO PINHITS RATIO
    -------------------- --------- --------- ------- -------- -------
    SQL AREA 8397 7557 .90 32263 .95
    TABLE/PROCEDURE 4707 3971 .84 7365 .78
    BODY 333 309 .93 333 .93
    TRIGGER 69 51 .74 69 .48
    INDEX 28 0 .00 28 .00
    CLUSTER 371 363 .98 445 .98
    OBJECT 0 0 1.00 0 1.00
    PIPE 0 0 1.00 0 1.00

    Thanks
    Anurag

  2. #2

    Smile

    I don't think you have to be worried about this because the "GETS" numbers are all very small which means you don't use them much. So the RATIOs don't mean anything.
    Just wait and let the numbers grow. Then the RATIOs will show the fair values.
    Queyon Zeng

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