Oracle
1Z0-054 · Question #47
The OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter is set to TRUE for a 24x7 database instance. The space consumption has significantly increased by the automatically captured plan baselines. You…
The correct answer is B. purging the older SQL management objects D. increasing the size of the SYSAUX tablespace. See the full explanation below for the reasoning.
Question
The OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter is set to TRUE for a 24x7 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.)
Options
- Aincreasing the AWR retention period
- Bpurging the older SQL management objects
- Cincreasing the size of the SYSTEM tablespace
- Dincreasing the size of the SYSAUX tablespace
How the community answered
(40 responses)- A13% (5)
- B80% (32)
- C8% (3)
Community Discussion
No community discussion yet for this question.