SQL> CALL DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(8,30);
CALL DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(8,30);
[-20121]:RETENTION 的有效范围为 [1440, 52560000]
SQL> CALL DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(52560000,30);
DMSQL 过程已成功完成
已用时间: 89.629(毫秒). 执行号:305.
SQL>
SQL>
SQL> SELECT * FROM SYS.WRM$_WR_CONTROL;
行号 DBID SNAP_INTERVAL
---------- ----------- -----------------------------------------
RETENTION TOPNSQL
-------------------------------------------- -----------
STATUS_FLAG
-----------
1 NULL INTERVAL '0 0:30:0.0' DAY(5) TO SECOND(1)
INTERVAL '36500 0:0:0.0' DAY(5) TO SECOND(1) 30
1
已用时间: 0.263(毫秒). 执行号:306.
