Which action would allow you to perform the preceding task successfully?

You plan to use adaptive thresholds as part of the performance tuning activity. You decide to
increase the window size of the default moving window baseline for all metric observations and
comparisons in your database. The following error occurs when you try to increase the window
size through Enterprise Manager:
Failed to commit: ORA-13541: system moving window baseline size (1296000) greater than
retention (1036800) ORA-06512: at “SYS.DBMS_WORKLOAD_REPOSITORY”, line 601 ORA-06512: at line 2 Which action would allow you to perform the preceding task successfully?

You plan to use adaptive thresholds as part of the performance tuning activity. You decide to
increase the window size of the default moving window baseline for all metric observations and
comparisons in your database. The following error occurs when you try to increase the window
size through Enterprise Manager:
Failed to commit: ORA-13541: system moving window baseline size (1296000) greater than
retention (1036800) ORA-06512: at “SYS.DBMS_WORKLOAD_REPOSITORY”, line 601 ORA-06512: at line 2 Which action would allow you to perform the preceding task successfully?

A.
increasing the flashback retention period

B.
increasing the retention period for SQL Management Base

C.
increasing the undo retention period for the database instance

D.
increasing the Automatic Workload Repository (AWR) retention period



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

system moving window size is depending on AWR retention period

So D is right.