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

is this actually causing you a problem? Why are you tuning with ratios - that went out years and years ago

Hi :

Use statpack :
Better way for tuning the database,.


Bhushan

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.

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

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.

i give up, who's to say it is low? - maybe that value is absolutely perfect for you