utlbstat and utlestat - Producing Oracle Statistic Report
---------------------
utlbstat is an Oracle script that creates a starting snapshot of most Oracle statistics
To create a starting snapshot run utlbstat:
Connect using svrmgrl:
connect internal
@?/rdbms/admin/utlbstat.sql
exit
---------------------
utlestat is an Oracle script that creates an end snapshot of most Oracle statistics. It also produces a report called report.txt of the
Oracle stats since the utlbstat snapshot was done.
To create a end snapshot run utlestat:
cd to the direcory where you want the report.txt file to be created.
Connect using svrmgrl:
connect internal
@?/rdbms/admin/utlestat.sql
exit
At this point you may want to copy the report.txt to a different file name so that it doesn't get overwritten the next time
you run utlestat.
|