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）
解析：
DBMS_SPM.CONFIGURE, 该过程为SQL Management base设置参数.
该函数可以调用多次,每次设置不同的配置选项.
space_budget_percent, SYSAUX空间中可以用于SQL Management base的最大比例
plan_retention_weeks, 未被使用的计划在删除之前的保留期