You can use the STATSPACK utility to monitor the performance of your database. In this chapter, you will see how to install STATSPACK, how to manage it, and how to run and interpret the reports generated.

As of Oracle10g, you can use the Automatic Workload Repository to gather and analyze statistics. The STATSPACK utility provides an ad hoc capability to analyze database statistics in a similar fashion—by taking snapshots of the database statistics at different times and generating reports based on the differences.

Installing STATSPACK

STATSPACK must be installed in every database to be monitored. The installation script, named spcreate.sql, is found in the /rdbms/admin subdirectory under the Oracle software home directory. ...

Get Oracle Database 10g DBA Handbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.