oracle.1z0-053:Observe the following PL/SQL block:

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.
Answer: D
Explanation:

spm:sql plan management.

CONFIGURE Procedure

This procedure sets configuration options for SQL management base, in parameter/value format. This function can be called numerous times, each time setting a different configuration option.

Syntax

DBMS_SPM.CONFIGURE (

   parameter_name    IN VARCHAR2,

   parameter_value   IN NUMBER);

Parameters

Table 136-5 CONFIGURE Procedure Parameters

Parameter	Description
parameter_name	Name of parameter to set (see table below)
parameter_value	Value of parameter to use (see table below)

 

Table 136-6 Names & Values for CONFIGURE Procedure Parameters

Name	Description	Possible Values	Default Value
space_budget_percent	Maximum percent of SYSAUX space that can be used for SQL management base	1,2, …, 50	10
plan_retention_weeks	Number of weeks to retain unused plans before they are purged	5,6, …, 523	53

 

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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29555029/viewspace-1601869/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29555029/viewspace-1601869/