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 ...