Which two options would you use to increase the purge interval? (Choose two)

While observing database statistics, you found that the Automatic Workload Repository (AWR) snapshots are being purged after each day. You want the snapshots to be purged on a weekly basis.
Which two options would you use to increase the purge interval? (Choose two)

While observing database statistics, you found that the Automatic Workload Repository (AWR) snapshots are being purged after each day. You want the snapshots to be purged on a weekly basis.
Which two options would you use to increase the purge interval? (Choose two)

A.
Enterprise Manager

B.
DBMS_JOB.INTERVAL

C.
DBMS_SCHEDULER.CHANGE

D.
DBMS_SCHEDULER.INTERVAL

E.
DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS



Leave a Reply 0

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