Library cache Misses

[dhar_kiran]

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

[davey23uk]

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

[BHUSHAN]

Hi :

Use statpack :
Better way for tuning the database,.


Bhushan

[dhar_kiran]

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.

[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

[dhar_kiran]

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.

[davey23uk]

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