Note
This view is available starting with V4.0.0.
Overview
Displays the configuration parameters in the SPM of the current tenant.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| PARAMETER_NAME | varchar(128) | NO | Parameter name:
|
| PARAMETER_VALUE | text | YES | Value of the parameter |
| LAST_MODIFIED | timestamp(6) | YES | Last Update Time of Parameter Value |
| MODIFIED_BY | varchar(128) | NO | User Who Last Updated the Parameter Value |
Sample query
View the configuration parameters in the SPM of the current tenant.
obclient[oceanbase]> SELECT * FROM oceanbase.DBA_SQL_MANAGEMENT_CONFIG;
The query result is as follows:
+----------------------------------+-----------------+----------------------------+-------------+
| PARAMETER_NAME | PARAMETER_VALUE | LAST_MODIFIED | MODIFIED_BY |
+----------------------------------+-----------------+----------------------------+-------------+
| AUTO_CAPTURE_ACTION | NULL | 2025-04-27 10:30:29.306370 | NULL |
| AUTO_CAPTURE_MODULE | NULL | 2025-04-27 10:30:29.306370 | NULL |
| AUTO_CAPTURE_PARSING_SCHEMA_NAME | NULL | 2025-04-27 10:30:29.306370 | NULL |
| AUTO_CAPTURE_SQL_TEXT | NULL | 2025-04-27 10:30:29.306370 | NULL |
| AUTO_SPM_EVOLVE_TASK | OFF | 2025-04-27 10:30:29.306370 | NULL |
| AUTO_SPM_EVOLVE_TASK_INTERVAL | 3600 | 2025-04-27 10:30:29.306370 | NULL |
| AUTO_SPM_EVOLVE_TASK_MAX_RUNTIME | 1800 | 2025-04-27 10:30:29.306370 | NULL |
| PLAN_RETENTION_WEEKS | 53 | 2025-04-27 10:30:29.306370 | NULL |
| SPACE_BUDGET_PERCENT | 10 | 2025-04-27 10:30:29.306370 | NULL |
+----------------------------------+-----------------+----------------------------+-------------+
9 rows in set
References
View the SPM plan evolution information of the current tenant: DBA_OB_SPM_EVO_RESULT
View the plan baseline of SQL statements in the SPM of the current tenant: DBA_SQL_PLAN_BASELINES
For more information about the SPM evolution mechanism, see Execution plan management.