Library cache Misses
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Library cache Misses

  1. #1
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78

    Library cache Misses

    The query
    select sum(pinhits)*100/sum(pins) from v$librarycache
    results cache hit <= 80%

    if I check freespace in sharedpool from
    select * from v$sgastat where name like '%free%'
    it always gives me 22 MB free and also used sharable memory remains almost 3 MB

    Other settings are

    open_cursors=300
    Session_cached_cursors=100
    cursor_sharing=force

    Could anyone suggest me, what should i do to make Library cache hit 99%

    Thanks in advance
    ~KD.DBA~

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    is this actually causing you a problem? Why are you tuning with ratios - that went out years and years ago

  3. #3
    Join Date
    Jan 2002
    Posts
    50
    Hi :

    Use statpack :
    Better way for tuning the database,.


    Bhushan

  4. #4
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    Quote Originally Posted by davey23uk
    is this actually causing you a problem? Why are you tuning with ratios - that went out years and years ago

    How should I check then and what should I do, to make Library cache hit >= 99%

    Thanks in advance.
    ~KD.DBA~

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    what I am asking, do you have an actual problem you are investigating which you have pinned down to this area. Or are you just seeing this number and attempting to change it

  6. #6
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    Quote Originally Posted by davey23uk
    what I am asking, do you have an actual problem you are investigating which you have pinned down to this area. Or are you just seeing this number and attempting to change it
    Problem is that Library cache hit is low and nothing is pinned. I want to make it above 95%, what should i do, if I have figures already mentioned in this thread.
    ~KD.DBA~

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    i give up, who's to say it is low? - maybe that value is absolutely perfect for you

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