（103）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）

解析：

DBMS_SPM.CONFIGURE, 该过程为SQL Management base设置参数.

该函数可以调用多次,每次设置不同的配置选项.

space_budget_percent, SYSAUX空间中可以用于SQL Management base的最大比例

plan_retention_weeks, 未被使用的计划在删除之前的保留期

ITPub博客

Oracle 11G OCP 1Z0-053 103