Note
This view is available starting with V2.2.77.
Purpose
This view displays the session variables of the current tenant.
Applicability
This view is applicable only to OceanBase Database in Oracle mode.
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 in 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 in the current tenant: TENANT_VIRTUAL_GLOBAL_VARIABLE
For more information about tenant system variables, see Tenant system variables.