Note
This view is available starting with V1.4.
Purpose
This view records information about all session variables, including hidden variables that start with an underscore (_).
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| VARIABLE_NAME | varchar(128) | NO | The name of the session variable. |
| VARIABLE_VALUE | varchar(1024) | YES | The value of the session variable. |
Sample query
Query the value of the ob_trx_timeout session variable.
obclient [oceanbase]> SELECT * FROM information_schema.SESSION_VARIABLES WHERE VARIABLE_NAME='ob_trx_timeout';
The query result is as follows:
+----------------+----------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+----------------+----------------+
| ob_trx_timeout | 86400000000 |
+----------------+----------------+
1 row in set