CHAPTER 9 Using STATSPACK
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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
