OracleASH & AWR
Take an AWR snapshot now
Takes 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.
Not yet verified. How scripts are tested
1EXEC DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT;Save it as ora-awr-snap-now.sql and run it with SQL> @ora-awr-snap-now.
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.
- 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.