Hi,

Here is a small statistics report I get about the performance of my database daily;;

I note that
1)

AVERAGE HIT RATIO
-----------------
91.9043446


Average hit ratio seems to be decreasing from 96 to 91 (gradually) Is this a matter of consern. What is the Average hit ratio that is optimum

2)
********************** Hit Ratio by User *****************

SID USERNAME CONSISTENT_GETS BLOCK_GETS PHYSICAL_READS hitratio
---------- -------- --------------- ---------- -------------- ----------
35 REI 4792 14 3932 18.1856013
48 REI 418110 1238 341465 18.5724029
66 REI 18584 153 774 95.8691359

Here in case of the user wise hit ratio's some sid's have a very low hitratio and some have good ratio (95.9). How is this being caused,

Please advise

Badrinath