-
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~
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
|