Hi Guys.

I want to ask why my hit ration decrease below than 20 %.?
For your information I analyze tables and indexes almost once a weeks.
Most of my tables and indexes extents have been reconstruct lest than 3 extents.

Please give some ideas to help me to overcome the problem?. or give some sugestion to overcome the problem.
(oracle 7.3)

Thanks.



Oracle LazyDBA home page