Note
This view is available starting with V4.0.0.
Purpose
This view displays the configuration parameters in the SQL plan management (SPM) of the current tenant.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| PARAMETER_NAME | VARCHAR2(128) | NO | The name of the configuration parameter. Valid values: |
| PARAMETER_VALUE | text | YES | The value of the configuration parameter. |
| LAST_MODIFIED | TIMESTAMP(6) | NO | The time when the parameter value was last updated. |
| MODIFIED_BY | VARCHAR2(128) | NO | The object that updated the parameter value last. |
Sample query
Query the configuration parameters in the SPM of the current tenant.
obclient[SYS]> SELECT * FROM SYS.DBA_SQL_MANAGEMENT_CONFIG;
The query result is as follows:
+----------------------------------+-----------------+------------------------------+-------------+
| PARAMETER_NAME | PARAMETER_VALUE | LAST_MODIFIED | MODIFIED_BY |
+----------------------------------+-----------------+------------------------------+-------------+
| AUTO_CAPTURE_ACTION | NULL | 27-APR-25 10.31.31.968791 AM | NULL |
| AUTO_CAPTURE_MODULE | NULL | 27-APR-25 10.31.31.968791 AM | NULL |
| AUTO_CAPTURE_PARSING_SCHEMA_NAME | NULL | 27-APR-25 10.31.31.968791 AM | NULL |
| AUTO_CAPTURE_SQL_TEXT | NULL | 27-APR-25 10.31.31.968791 AM | NULL |
| AUTO_SPM_EVOLVE_TASK | OFF | 27-APR-25 10.31.31.968791 AM | NULL |
| AUTO_SPM_EVOLVE_TASK_INTERVAL | 3600 | 27-APR-25 10.31.31.968791 AM | NULL |
| AUTO_SPM_EVOLVE_TASK_MAX_RUNTIME | 1800 | 27-APR-25 10.31.31.968791 AM | NULL |
| PLAN_RETENTION_WEEKS | 53 | 27-APR-25 10.31.31.968791 AM | NULL |
| SPACE_BUDGET_PERCENT | 10 | 27-APR-25 10.31.31.968791 AM | NULL |
+----------------------------------+-----------------+------------------------------+-------------+
9 rows in set
References
Query the evolution information of the SPM plans of the current tenant: DBA_OB_SPM_EVO_RESULT
Query the plan baselines of SQL statements in the SPM of the current tenant: DBA_SQL_PLAN_BASELINES
For more information about the SPM evolution mechanism, see Manage execution plans.