DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, March 23, 2016

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;

No comments: