How to generate AWR shapshots for every 30 minutes with retention of 30 days period
February 14, 2018
Setting AWR Snapshots: 30-Minute Intervals,30-Day Retention
Step 1: Get the size of current moving window size. SQL> select moving_window_size from dba_hist_baseline wh…