I seem to remember in oracle 7 a similar situation, (and maybe later
releases) where dropping completely and rebuilding helped.

-----Original Message-----
From: Eric Levinson
[mailto:oracledba-ezmlmshield-x12975794.[Email address protected]
Sent: Thursday, September 08, 2005 3:20 PM
To: LazyDBA Discussion
Subject: RE: Hit Ratio

Some things to try:

1) Drop and recreate indexes
2) Increase your SGA, buffer cache size
3) If possible, full export and import of the db on a test environment

I came across several examples in 7.3 where statistics are incorrectly
calculated and rebuilding indexes didn't work, the same bad data kept
getting copied, it took us dropping and recreating all indexes.

Eric


-----Original Message-----
From: Mohamad Mathurudi Rejab
[mailto:oracledba-ezmlmshield-x54281176.[Email address protected]
Sent: Wednesday, September 07, 2005 5:52 PM
To: LazyDBA Discussion
Subject: Hit Ratio

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.




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page