AWR (automatic workload repository) of Oracle
#################### AWR (automatic workload repository) of Oracle #################### Retention period of AWR report: select retention from dba_hist_wr_control; /*If we have more than 7 days,we can reduce it to 7 day which is 7*24*60 = 10080 minutes. the retention period is modified to 7 days (10080 minutes) and the interval between each snapshot is 60 minutes through below query. */ execute dbms_workload_repository.modify_snapshot_settings (interval => 60,retention => 10080); In case while reducing the retention period if we face an error then check the MOVING_WINDOW_SIZE value with below query SELECT moving_window_size FROM dba_hist_baseline WHERE baseline_type = 'MOVING_WINDOW'; exec DBMS_WORKLOAD_REPOSITORY.modify_baseline_window_size( window_size =>7); Then update it to correct value and then execute the above AWR retention query. execute dbms_workload_repository.modify_snapshot_settings (interval => 60,retention => 10080); Once the...