Oracle Real Application Clusters

13.2 UTLBSTAT/UTLESTAT

The UTLBSTAT/UTLESTAT scripts are designed to provide a summary of Oracle activity over a reasonable period of time (>10 minutes). UTLBSTAT creates a snapshot of some of the internal Oracle dynamic performance views (V$ views). UTLESTAT creates a second snapshot of these views and reports on the differences between the two snapshots to a file called report.txt.

The UTLBSTAT/UTLESTAT scripts are shipped as standard with all Oracle releases. In Version 8.1.6 there is a new tool called STATSPACK which has improved functionality over what UTLBSTAT/UTLESTAT offer. Using STATSPACK you can collect more statistical information and store the performance statistics data permanently in Oracle tables enabling snapshot reporting.