TENANT_VIRTUAL_GLOBAL_VARIABLE

Purpose

This view displays the information about all global variables in the current tenant.

Columns

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.