Tuesday, September 16, 2008

AWR snaps and reports

# take a snapshot

EXEC DBMS_WORKLOAD_REPOSITORY.create_snapshot;

# Run a report

@$ORACLE_HOME/rdbms/admin/awrrpt.sql