Someone start using hard coded variables?

Select username from table where ssn = '123456789'?

Someone doing ad hoc queries that are badly written?

Running out of memory all of a sudden?

-----Original Message-----
From: Mohamad Mathurudi Rejab
[mailto:oracledba-ezmlmshield-x54281176.[Email address protected]
Sent: Wednesday, September 07, 2005 8: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



Oracle LazyDBA home page