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博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1253557/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17013648/viewspace-1253557/