-
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~
-
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
-
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~
-
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
-
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~
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|