UTLBSTAT/UTLESTAT
These two scripts collect data from the V$ data dictionary views and save it to tables in the database.
The UTLBSTAT script collects the initial statistics into a set of tables and also creates tables for the ending statistics. The UTLESTAT script collects the ending statistics and creates a set of tables that show the differences between the beginning and ending statistics.
The tables created have the names shown in the following list. Unless otherwise noted, the beginning statistics tables use the name format of STATS$BEGIN_*, the ending statistics tables use the format of STATS$END_*, and the differences tables use the format of STATS$*.
- *DC
For dictionary cache statistics.
- *EVENT
For wait statistics.
- *FILE
For file I/O statistics. The difference table is named STATS$FILES.
- *LATCH
For latch statistics. The difference table is named STATS$LATCHES.
- *LIB
For library cache statistics.
- *ROLL
For rollback segment statistics.
- *STATS
For system statistics.
- STATS$DATES
Contains beginning date and time after running UTLBSTAT and both beginning and ending time after running UTLESTAT.
UTLBSTAT and UTLESTAT always use the same tables for saving the statistics, so you can look at only one set of differences at a time with them. If you want to look at multiple sets of differences, you can save the information in the DIF tables to another set of tables or create reports from them, for comparison with other sets of statistics.