Purpose
This view displays all global 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 variable. |
| VALUE | VARCHAR2(65536) | YES | The value of the variable. |
Sample query
Query the value of the global variable max_user_connections of 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 of the current tenant: TENANT_VIRTUAL_SESSION_VARIABLE
For more information about tenant system variables, see Tenant system variables.