Note
This view is available starting with V5.0.1.
Overview
The CDB_OB_SYS_VARIABLE_HISTORY view displays the modification history of all global system variables for all tenants.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| 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 all tenants under the sys tenant.
obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.CDB_OB_SYS_VARIABLE_HISTORY WHERE NAME = 'ob_query_timeout';
The query result is as follows:
+-----------+------------------+-----------+----------------------------+
| TENANT_ID | NAME | VALUE | MODIFY_TIME |
+-----------+------------------+-----------+----------------------------+
| 1 | ob_query_timeout | 10000000 | 2026-06-24 17:33:38.573748 |
| 1001 | ob_query_timeout | 10000000 | 2026-06-24 17:34:34.425407 |
| 1002 | ob_query_timeout | 10000000 | 2026-06-24 17:34:34.323366 |
| 1003 | ob_query_timeout | 10000000 | 2026-06-24 17:34:44.324301 |
| 1004 | ob_query_timeout | 10000000 | 2026-06-24 17:34:44.384848 |
| 1004 | ob_query_timeout | 20000000 | 2026-06-25 11:26:13.139296 |
+-----------+------------------+-----------+----------------------------+
6 rows in set