The CONFIGURE procedure sets some parameters for SPM.
Syntax
DBMS_SPM.CONFIGURE (
parameter_name IN VARCHAR2,
parameter_value IN NUMBER
);
Parameters
| Parameter | Description |
|---|---|
| database_name | The name of the database. This parameter is required only in MySQL-compatible mode. |
| parameter_name | The name of the parameter to be set. For more information, see SPM parameters. |
| parameter_value | The value to which the parameter is to be set. For more information, see SPM parameters. |
SPM parameters
| SPM parameter | Description | Possible values | Default value |
|---|---|---|---|
| space_budget_percent | The maximum percentage of SYSAUX space allowed for SPM. | 1, 2, ..., 50 | 10 |
| plan_retention_weeks | The number of weeks after which a plan that has not been used will be automatically discarded. | 5, 6, ..., 523 | 53 |
Examples
Set the plan to be automatically purged if not used within 20 weeks.
BEGIN
DBMS_SPM.CONFIGURE ('plan_retention_weeks', 20);
END;