===== ORA-13516: AWR Operation failed: INTERVAL Setting is ZERO

The above error message is because of the INTERVAL of snapshot setting is Zero. You can change the snapshot setting by using the following command. The below command set the interval to 60 mins

DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS( INTERVAL=>60 );

Comments are closed.