All kinds of oracle awr generation scripts
An instance @ $ORACLE_HOME/rdbms/admin/awrrpt.sql RAC report @ $ORACLE_HOME/rdbms/admin/awrgrpt.sql specify an instance @ $ORACLE_HOME/rdbms/admin/awrrpti.sql specify an instance @ $ORACLE_HOME/rdbms/admin/awrgrpti.sql to report for a sql_id @ $ORACLE_HOME/rdbms/admin/awrsqrpt.sql to report for a database instance sql_id @ $ORACLE_HOME/rdbms/admin/ A report on the scope of awrsqrpi.sql single instance comparison to snap_id. @ $ORACLE_HOME/rdbms/admin/awrddrpt.sql RAC compare reports of different ranges @ $ORACLE_HOME/rdbms/admin/awrgdrpt.sql RAC reports comparing specific instances @ $ORACLE_HOME/rdbms/admin/awrddrpi.sql ash reports @ $ORACLE_HOME/rdbms/admin/ashrpt.sql generate ash reports @ $ORACLE_HOME/rdbms/admin/ashrpti.sql RAC ash reports @ $ORACLE_HOME/rdbms/admin/ashrpti.sql 1 for an instance Create awr BEGIN DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT () END; / 2, delete BEGIN DBMS_WORKLOAD_REPOSITORY.DROP_SNAPSHOT_RANGE (low_snap_id = > 22, high_snap_id = > 32, dbid = > 3310949047); END; / 3, modify configuration BEGIN DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS (retention = > 43200, interval = > 30, topnsql = > 100, dbid = > 3310949047); END; / configuration information is in DBA_HIST_WR_CONTROL.