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

Trend-based Oracle Reconfiguration

A common approach to trend-based reconfiguration is to use STATSPACK historical data to proactively reconfigure the database. A good analogy is just-in-time manufacturing, where parts appear on the plant floor just as they are needed for assembly. Oracle enables the DBA to anticipate processing needs and regularly schedule appropriate intervention, insuring that SGA resources are delivered just-in-time for processing tasks.

For those who would like to investigate STATSPACK features and abilities at a deeper level, two informative books are available from Oracle Press:

  • Oracle High-performance Tuning with STATSPACK - Oracle Press, by Donald K. Burleson.

  • Oracle High-performance Tuning with STATSPACK - Oracle Press, by Donald K. Burleson.

The entire range of techniques and options available for trend identification using STATSPACK are beyond the scope of this book. We will concentrate here on examining STATSPACK reports that indicate trends in the behavior of the data buffer pools. Average data buffer hit ratios can be generated along two dimensions:

  • Average DBHR by day of the week

  • Average DBHR by hour of the day

Either of these reports will supply invaluable information for spotting usage trends in the Oracle database. Change occurs in the data buffers rapidly, and sometimes a long-term analysis will provide clues that point to processing problems within the database. Almost every Oracle database exhibits patterns that are linked to regular processing schedules, called signatures. The following sections will plot the average data buffer hit ratio for an Oracle database over different intervals.

 

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 share 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.