SOLVED

ORA-13541: System Moving Window Baseline Size Greater Than Retention.

Asked by OracleDba••11 views•oracle
1
2
3
4
5
ORA-13541: System Moving Window Baseline Size Greater Than Retention.

PROBLEM:

While modifying the retention period of AWR snapshot, we got this error.
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Let’s check the Moving window size:

SQL> select BASELINE_TYPE,MOVING_WINDOW_SIZE from dba_hist_baseline;

BASELINE_TYPE MOVING_WINDOW_SIZE

------------- ------------------

MOVING_WINDOW 8

It is set to 8 days. I.e the moving window size is more than the retention period we are trying to set.

So modify the window size to  7 days.

SQL> execute dbms_workload_repository.modify_baseline_window_size(window_size=> 7);

PL/SQL procedure successfully completed.

SQL> select BASELINE_TYPE,MOVING_WINDOW_SIZE from dba_hist_baseline;

BASELINE_TYPE MOVING_WINDOW_SIZE

------------- ------------------

MOVING_WINDOW 7

Now try to modify awr snapshot retention:

SQL> execute dbms_workload_repository.modify_snapshot_settings (interval => 30, retention => 10080);

PL/SQL procedure successfully completed.
OracleDba•

Post Your Solution