Call (800) 766-1884 for Oracle support & training
Free Oracle Tips


Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance
 

Free Oracle Tips


 

HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

 

 

   
  Oracle Tips by Burleson

Oracle’s Seven Data Buffer Hit Ratios

We have seen that the data buffer hit ratio is a common metric used by Oracle tuning experts to measure the propensity of a row to be in the data buffer. For example, a hit ratio of 95 percent means that 95 percent of row requests were already present in the data buffer, thereby avoiding an expensive disk I/O. In general, as the size of the data buffers is increased, the DBHR will also increase and approach 100 percent.

Oracle has a separate data buffer hit ratio for all seven data buffer caches. For optimum performance, the Oracle DBA should constantly monitor all seven data buffers and adjust their size, based on each data buffer hit ratio. Oracle provides the exciting feature of allowing the number of RAM buffers within any of the data buffer caches to be changed dynamically.

This is done through alter system commands that allow the size of the buffers to be changed while Oracle remains available. This means that the DBA can maximize performance in response to current statistics by manually de-allocating RAM from one data buffer and shifting it to another buffer cache.

The general rule is that the more data that can be retrieved from a single I/O, the better the overall hit ratio. However, we need to delve a little deeper to get a more complete understanding of how multiple data buffers operate.

 

The above text is an excerpt from "Creating a Self Tuning Oracle Database", by Rampant TechPress.  It is only $9.95 and all scripts in this tips can be immediately downloaded.


Complete Oracle Script Collection Available

Burleson Consulting shares their personal arsenal of Oracle data dictionary scripts in this comprehensive download. With decades of experience using Oracle monitoring scripts and Oracle tuning scripts, BC experts shares their secrets for navigating the Oracle data dictionary.

Packed with 681 ready-to-use Oracle scripts, this is the definitive collection for every senior Oracle DBA.

It would take man-years to develop these scripts from scratch, making this download the best value in the Oracle industry.

BC has priced this collection of 681 scripts at $79.95.  You can download them immediately at this link:

http://www.rampant-books.com/download_adv_mon_tuning.htm

 

 

  
 

Oracle performance tuning software 
 
 
 
 

Oracle performance tuning book

 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 

 

   

Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.