Observe the following PL/SQL block:
BEGIN
dbms_spm.configure(‘SPACE_BUDGET_PERCENT’, 30);
END;
Which statement is correct regarding the above PL/SQL block?
A.
It automatically purges the SQL management objects when SMB occupies more than 30% of
the SYSAUX tablespace.
B.
It reserves 30% of the space in the SYSAUX tablespace for SQL Management Base (SMB).
C.
It reserves 30% of the space in the SYSTEM tablespace for SMB.
D.
It generates a weekly warning in the alert log file when SMB occupies more than 30% of the
SYSAUX tablespace.
Asnwer B.
“space_budget_percent
Maximum percent of SYSAUX space that can be used for SQL management base”
http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_spm.htm#CACHAGGA
D is correct
“space_budget_percent – Maximum percent “, but not reserved
Usage Notes
When the space occupied by SQL management base exceeds the defined space budget limit, a weekly database alert is generated.
The correct answer is D
Disk space used by the SQL management base is regularly checked against a limit based on the size of the SYSAUX tablespace. By default, the limit for the SMB is no more than 10% of the size of the SYSAUX tablespace. The allowable range for this limit is between 1% and 50%. A weekly background process measures the total space occupied by the SMB, and when the defined limit is exceeded, the process will generate a warning that is written to the alert log. The alerts are generated weekly until either the SMB space limit is increased, the size of the SYSAUX tablespace is increased, or the disk space used by the SMB is decreased by purging SQL management objects (SQL plan baselines or SQL profiles).