Generate AWR Snapshot Manually

Automatic Workload Repository (AWR) is a collection of database statistics owned by the SYS user. By default snapshot are generated once every 60min .

But In case we wish to generate awr snapshot manually, then we can run the below script.  This is usually useful, when we need to generate an awr report for a non-standard window with smaller interval.

Lets say, we want to generate a report for next 15 minutes. (12:10 – 12:25) . So we will generate a snapshot at 12:10 and another at 12:25 .