Buffer Hit ratios - Oracle still hasn't got it

From: Peter McLarty <p.mclarty_at_cqu.edu.au>
Date: Thu, 26 Apr 2007 15:29:52 +1000
Message-ID: <27AA2E9CA7A0C44283BC1E9B00086AA9063B0DDC@UNIMAIL.staff.ad.cqu.edu.au>

I was just reading the 10.2 Performance Tuning Guide and found this little gem. I thought it should have been written out by now

"7.2.3.1 Increasing Memory Allocated to the Buffer Cache

As a general rule, investigate increasing the size of the cache if the cache hit ratio is low and your application has been tuned to avoid performing full table scans."

Clearly no one in Oracle has updated the Tech Writers for some time

Cheers

-- 
Peter McLarty
Database Administrator
Student System Upgrade Project
Central Queensland University

  Email:  p.mclarty_at_cqu.edu.au
 Phone:  07 4923 2876
   Fax:  07 4923 2721
Mobile:  04 0209 4238
 
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 26 2007 - 00:29:52 CDT