TO CHANGE THE SNAPSHOT SETTINGS


******************************************************************************************************************************************************************

    SELECT retention FROM dba_hist_wr_control;

    RETENTION
    —————————————————————————
    +00008 00:00:00.0

    1 row selected.

*********************************************************************************

    SQL>

The retention period is altered using the MODIFY_SNAPSHOT_SETTINGS procedure, which accepts a RETENTION parameter in minutes.

    BEGIN
      DBMS_WORKLOAD_REPOSITORY.modify_snapshot_settings(
        retention => 43200);  — Minutes (= 30 Days).
    END;
    /

    SELECT retention FROM dba_hist_wr_control;

  • March 22, 2016 | 14 views
  • Comments