Monitoring Oracle with utlbstat/utlestat

To illustrate the process of monitoring Oracle, we examine an Oracle9i report.txt file created with the utlbstat.sql and utlestat.sql scripts (described in “The utlbstat and utlestat Scripts” on page 313). The report is interspersed with comments about some of the highlights; my objective is to explore the main statistics that might require action rather than to attempt to explain every item.

Note that although we follow the order used by report.txt, the best way to begin understanding instance behavior is to examine wait events. The statspack scripts recognize this by reporting the top five wait events almost at the beginning of the report.

The Library Cache

The first section of the report deals with ...

Get Configuring and Tuning Databases on the Solaris™ Platform now with O’Reilly online learning.

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