||Oracle Tips by Burleson
Chapter 8 -
Miscellaneous Oracle Information
OCP Instructors Guide for
Oracle DBA Certification
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.
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
by Christopher T. Foot
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA