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

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


Free Oracle App Server Tips


Oracle support

Oracle training

Oracle tuning


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

Download your Oracle scripts now:

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.