The OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter is set to TRUE for a 24×7
database instance. The space consumption has significantly increased by the automatically
captured plan baselines. You are suggested to run the following block:
BEGIN
dbms_spm.configure(‘SPACE_BUDGET_PERCENT’, 30);
END;
After a few weeks of work, you observe warnings on exceeding space usage by SQL Management
Base (SMB) in alert log file. Which two actions can be solutions for this? (Choose two.)
A.
increasing the AWR retention period
B.
purging the older SQL management objects
C.
increasing the size of the SYSTEM tablespace
D.
increasing the size of the SYSAUX tablespace
A is wrong. increasing AWR retention period will use more space
B is right. purging
C is wrong. SPM is not in system
D is right.
So B.D. are correct