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.
DBMS_SPM.CONFIGURE (
parameter_name IN VARCHAR2,
parameter_value IN NUMBER);
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 |
- 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).
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29555029/viewspace-1601869/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29555029/viewspace-1601869/