Note
This view is available starting with V2.2.77.
Purpose
This view displays the information about all global variables in 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 variable. |
| VALUE | VARCHAR2(65536) | YES | The value of the variable. |
Sample query
Query the value of the max_user_connections global variable in the current tenant.
obclient[SYS]> SELECT * FROM SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE WHERE VARIABLE_NAME = 'max_user_connections';
The query result is as follows:
+----------------------+-------+
| VARIABLE_NAME | VALUE |
+----------------------+-------+
| max_user_connections | 0 |
+----------------------+-------+
1 row in set
References
Query the values of all session variables in the current tenant: TENANT_VIRTUAL_SESSION_VARIABLE
For more information about tenant system variables, see Tenant system variables.