OracleASH & AWR
Generate AWR, ASH, ADDM and SQL reports
Oracle's own report scripts. Each one prompts for the format, snapshot range and file name, then writes the report to your current directory.
Not yet verified. How scripts are tested
1-- Whole-database AWR report (text or HTML)2@?/rdbms/admin/awrrpt.sql3 4-- AWR report for one SQL_ID5@?/rdbms/admin/awrsqrpt.sql6 7-- Compare two periods8@?/rdbms/admin/awrddrpt.sql9 10-- ASH report for a time window11@?/rdbms/admin/ashrpt.sql12 13-- ADDM findings for a snapshot range14@?/rdbms/admin/addmrpt.sql15 16-- RAC: global AWR report across all instances17@?/rdbms/admin/awrgrpt.sqlSave it as ora-awr-reports.sql and run it with SQL> @ora-awr-reports.
More Oracle scripts: ASH & 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…
- 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.
- 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.