The OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter is set to TRUE for a24x7 database instance. The space consumption has significantly increased by the automaticallycaptured 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 SQLManagement 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
The OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter is set to TRUE for a24x7 database instance. The space consumption has
-
answerhappygod
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am