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 | VARCHAR2(128) | YES | Variable name |
| VALUE | VARCHAR2(65536) | YES | Variable value |
| MODIFY_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | Time of last modification |
Sample query
You can query the modification history of the system variable ob_query_timeout at the global level for the current tenant.
obclient(sys@oracle001)[SYS]> SELECT * FROM SYS.DBA_OB_SYS_VARIABLE_HISTORY WHERE NAME = 'ob_query_timeout';
The query result is as follows:
+------------------+-----------+------------------------------+
| NAME | VALUE | MODIFY_TIME |
+------------------+-----------+------------------------------+
| ob_query_timeout | 10000000 | 24-JUN-26 05.34.44.384848 PM |
| ob_query_timeout | 20000000 | 25-JUN-26 11.26.13.139296 AM |
+------------------+-----------+------------------------------+
2 rows in set