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

Home
Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients

 

Free Oracle Tips


 
HTML Text AOL

Free Oracle App Server Tips


 
HTML Text

Oracle support

Oracle training

Oracle tuning

Rednecks!

Remote Oracle

Custom Oracle Training

 

   
  Oracle Tips by Burleson

OCP Instructors Guide for Oracle DBA Certification

Chapter 8 - Miscellaneous Oracle Information

Monitor By Day So You Don’t Get Called at Night

Use UNIX’s CRON or the Windows platform AT scheduler to schedule the monitoring scripts to run during periods of low activity. Remember that data contained in the V$ tables is refreshed each time the database is started. As a result, performance statistics should be collected after the database has been active for a period of time (the longer the better). If performance information for a particular time period is required to solve a specific performance problem, administrators are able to use the BSTAT/ESTAT or STATSPACK utilities to collect the information.

Monitoring Space Utilization and Performance Statistics Historically

Monitoring space utilization and performance statistics historically provides the following benefits:

  • Historical space tracking allows the DBA to determine table and index growth characteristics. The DBA is able to trend a particular data object’s growth and size the data objects space utilization parameters accordingly.
     

  • The DBA is able to trend space utilization in tablespaces. The DBA will be able to determine how quickly space is being consumed in the various tablespaces that make up the database. Tablespaces that are not growing quickly do not need as much free space allocated to them as their faster growing counterparts.
     

  • Tracking tablespace growth allows the DBA to predict hardware upgrades months in advance.
     

  • Tracking extent numbers historically allows the DBA to track fast growing objects.
     

  • Tracking the various buffer hit ratios (data, shared pool, redo log), the number of active users and the number of reads and writes being performed in the system allows the DBA to trend database performance. The DBA will be able to track usage spikes. This will allow the DBA to forecast when performance will be good and provide a possible reason when performance degrades.
     


The above text is an excerpt from:


OCP Instructors Guide for Oracle DBA Certification
A Study Guide to Advanced Oracle Certified Professional Database
Administration Techniques

ISBN 0-9744355-3-8

by Christopher T. Foot
 

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


Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

 
 
 

Oracle performance tuning book

 

 

Oracle performance tuning software

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

 

email BC:


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

Oracle® is the registered trademark of Oracle Corporation.