Purpose
This view displays all session variables of the current tenant.
Applicability
This view is available starting with OceanBase Database.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| VARIABLE_NAME | VARCHAR2(128) | NO | The name of the session variable. |
| VALUE | VARCHAR2(65536) | YES | The value of the session variable. |
Sample query
Query the value of the session variable ob_query_timeout of the current tenant.
obclient[SYS]> SELECT * FROM SYS.TENANT_VIRTUAL_SESSION_VARIABLE WHERE VARIABLE_NAME = 'ob_query_timeout';
The query result is as follows:
+------------------+----------+
| VARIABLE_NAME | VALUE |
+------------------+----------+
| ob_query_timeout | 10000000 |
+------------------+----------+
1 row in set
References
Query the values of all global variables of the current tenant: TENANT_VIRTUAL_GLOBAL_VARIABLE
For more information about tenant system variables, see Tenant system variables.