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

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:

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.