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



BC Oracle tuning

Oracle training

Oracle support

Remote Oracle



  Oracle Tips by Burleson

Using Oracle STATSPACK for the Data Buffer Hit Ratio

STATSPACK uses the stats$buffer_pool_statistics table for monitoring buffer pool statistics. This table contains the following useful columns:

  • name - This column shows the name of the data buffer (KEEP, RECYCLE, or DEFAULT).

  • free_buffer_wait - This is a count of the number of waits on free buffers.

  • buffer_busy_wait - This is the number of times a requested block was in the data buffer but unavailable because of a conflict.

  • db_block_gets - This is the number of database block gets, which are either logical or physical.

  • consistent_gets - This is the number of logical reads.

  • physical_reads - This is the number of disk block fetch requests issued by Oracle. (Remember, this is not always a “real” read because of disk array caching.)

  • physical_writes - This is the number of physical disk write requests from Oracle. If you have a disk array, the actual writes are performed asynchronously.

These STATSPACK columns provide information that can be used to measure several important metrics, including the most important, the data buffer hit ratio.


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:




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.