Buffer Hit ratios - Oracle still hasn't got it
- From: "Peter McLarty" <p.mclarty@xxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 26 Apr 2007 15:29:52 +1000
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@xxxxxxxxxx
Phone: 07 4923 2876
Fax: 07 4923 2721
Mobile: 04 0209 4238
--
//www.freelists.org/webpage/oracle-l
Other related posts:
