OracleASH & AWR
Run an AWR report (one instance or all)
Oracle's AWR report scripts. The first reports on the instance you're connected to; the second is the global report across all RAC instances. Each prompts for the format and snapshot range.
Tested on 12c, 19c · verified Sep 2026
1-- This instance2@?/rdbms/admin/awrrpt.sql3 4-- All instances (RAC)5@?/rdbms/admin/awrgrpt.sqlSave it as ora-awr-run.sql and run it with SQL> @ora-awr-run.
More Oracle scripts: ASH & AWR
- Top SQL in the last hour (ASH)Statements with the most sampled activity in the last hour, split into CPU, user I/O and other waits. Each sample is roughly one second of database…
- Top wait events in the last hour (ASH)Where the database spent its time over the last hour, with CPU counted as its own line.
- What was running between two times (AWR ASH)For "it was slow at 2 a.m." questions. Prompts for a start and end time (YYYY-MM-DD HH24:MI) and ranks SQL and events from AWR's history, where each…
- AWR settings and recent snapshotsSnapshot interval and retention, then every snapshot from the last 24 hours. You need the snapshot IDs to run an AWR report.
- Generate AWR, ASH, ADDM and SQL reportsOracle's own report scripts. Each one prompts for the format, snapshot range and file name, then writes the report to your current directory.
- Take an AWR snapshot nowTakes a manual snapshot so an AWR report can cover exactly the window of a test or a batch run. Take one before and one after.