| low librarycache hit ratio for indexes... [message #171545] |
Wed, 10 May 2006 06:51  |
tridentadm
Messages: 142
Registered: March 2006
|
Senior Member |
|
|
this pertains to oracle9i .
the total shared pool alloted is 200MB.
the gethitratio for INDEXES is showing 58% . Other hitratios are above 90%
any reasons for the same.
whats the resolution ??
|
|
|
|
|
|
|
|
| Re: low librarycache hit ratio for indexes... [message #171659 is a reply to message #171590] |
Wed, 10 May 2006 21:51  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>> isnt it that hitratio's should be above 90%
No hard limit here. It is just a hit ratio.
Hit ratio's cannot be considered as a measure of performance.
Yes, they do indicate something. But it is not a measure with which one can qualify whether something is good or bad.
Infact you can programmatically bring any hit ratio's you want.
http://www.orafaq.com/forum/t/23453/0/
In this particular case, Just by looking at library cache hit ratio, you cannot derive
anything. It may be because of poorly written sql statements( not sharable). May your
applications are not using enough bind variables.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
