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.
D is correct:
https://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_spm.htm
space_budget_percent
Maximum percent of SYSAUX space that can be used for SQL management base
Usage Notes
The default space budget for SQL management base is no more than ten percent of the size of SYSAUX tablespace. The space budget can be set to a maximum of 50%. The default unused plan retention period is one year and one week, which means a plan will be automatically purged if it has not been used for more than a year. The retention period can be set to a maximum of 523 weeks (i.e. a little over 10 years).
When the space occupied by SQL management base exceeds the defined space budget limit, a weekly database alert is generated.