DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: V$librarycache

  1. #1
    Join Date
    Aug 2001
    Posts
    390
    I look into the V$librarycache table and I found some info but unclear so please help.


    1. PINS of SQL Area=-300932440 ------ why pins is negative ??? but the GETHITRATIO is reasonable =.95



    2. The GETHITRATIO on index is very poor=.281731


    everything else look ok

    can someone give me some hint about the above issues ???

    thanks

  2. #2
    Join Date
    Nov 2001
    Posts
    4
    You run the follwoing query in your database.
    If % Ratio is above 1% , increase SHARED_POOL_SIZE

    Select sum(pins) "Executions",
    sum(reloads) "Cache Misses Executing",
    sum(reloads)/(sum(pins) * 100) "%Ratio"
    from v$librarycache

    Thanks

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    The GETHITRATIO on index is very poor=.281731
    Do you mean that the value of GETHITRATIO in v$librarycache is 0.28 for index namespace? Don't worry abou that.

    Check:

    select gethitratio from v$librarycache where namespace = 'SQL AREA';

    This should be in the high 90s. If not, we cannot do much about it. It is the developers' fault :-)


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