Title: Message
A
library cache hitmeans that when parsing a statement the object definition
is already found in the cached data dictionary (likely it has been recently
used). A library cache miss means that it aint there.
Now if
you can explain to your line of business boss why you would
Keep reading the same stuff from the indexes in a useless loop. That should
improve it. Or use Connor McDonald's script on oracledba.co.uk to get any
hitrate you like.
Seriously, hitratios don't mean a thing. Long story. Don't worry.
AK wrote:
found that gethitratio in