Create Manual Snapshots and Generate AWR Report for Database Create Manual Snapshot . Login to the database using SYS user. Generating an AWR Report The awrrpt.sql SQL script generates an HTML or text report that displays statistics for a range of snapshot Ids. How To Generate ASH Report September 17, 2011 | Filed under: Oracle. Active Session History (ASH) is a very important feature to analyze sessions in Oracle to troubleshoot transient problems that last for just few minutes. ASH reports gives the details needed to analyze the sessions. OEM (Oracle Enterprise Manager) makes it really easy to extract different reports like AWR, ADDM. But certain times, when OEM is down for some reasons or if the project is run outside of our dedicated environment that doesn't have OEM, we extract the reports manually. Here's how - — Connect to sqlplus using the Oracle credentials: To manually create a snapshot: SQL> exec perfstat.statspack.snap; Once you have at least two snapshots created, you can run the performance reports. There are two reports available - an Instance report, and a SQL report. The Instance Report (spreport.sql) is a general instance health report, covering all aspects of instance performance. Manual Automatic Workload Repository AWR snapshot collection and retention Manual Automatic Workload Repository AWR snapshot collection and retention allowing you to run the AWR snapshot reports on the preserved baseline snapshots at any time and compare them to recent snapshots Manually Running ADDM to Analyze Historical Database Performance. You can run ADDM manually to analyze historical database performance by selecting a pair or range of AWR snapshots as the analysis period. This technique is useful when you have identified a time period in the past when database performance was poor. Home > Miscellaneous > Create AWR reports manually Create AWR reports manually. October 9, 2012 Bharat Leave a comment Go to comments. 1. Creating Snapshot Run