Collecting statistics | Oracle DBA Tutorials pdf

Collecting statistics

Run UTLBSTAT and UTLESTAT to collect all database activities in the given time period in a single file.
Run from $ORACLE_HOME/rdbms/admin/utlbstat.sql and utlestat.sql
The resulting file is named as REPORT.TXT

=> Statspack

=> Run spcreate.sql script from $ORACLE_HOME/rdbms/admin folder.
=> It will create PERFSTAT schema with all required objects.
=> To collect statistics, use EXECUTE STATSPACK.SNAP procedure (as PERFSTAT user). A snapshot of statistics will be collected and stored in PERFSTAT schema tables.
=> Use $ORACLE_HOME/rdbms/admin/spauto.sql to run automatic statistics collection at specific intervals.
=> Once you gathered enough statistics, you can generate a report using $ORACLE_HOME/rdbms/admin/spreport.sql script.