Re: get hit ration

[Mogens N�rgaard]

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 v$librarycahce is very low for indexes. what does it mean ? is there any way to improve this .

 

thanks,

-ak