Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page