Note
This view is available starting with V5.0.1.
Overview
The DBA_OB_SYS_VARIABLE_HISTORY view displays the modification history of all global system variables for the current tenant.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| NAME | varchar(128) | NO | Variable name |
| VALUE | varchar(65536) | YES | Variable value |
| MODIFY_TIME | timestamp(6) | NO | Modified At |
Sample query
Query the modification history of the system variable ob_query_timeout at the global level for the current tenant in the sys tenant.
obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_SYS_VARIABLE_HISTORY WHERE NAME = 'ob_query_timeout';
The query result is as follows:
+------------------+----------+----------------------------+
| NAME | VALUE | MODIFY_TIME |
+------------------+----------+----------------------------+
| ob_query_timeout | 10000000 | 2026-06-24 17:33:38.573748 |
+------------------+----------+----------------------------+
1 row in set