Note
This view is introduced since OceanBase Database V1.4.
Purpose
This view displays the global server status variables of OceanBase Database, including the current number of active connections, database uptime, and more.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| VARIABLE_NAME | varchar(128) | NO | The name of the variable corresponding to the global status. |
| VARIABLE_VALUE | varchar(1024) | YES | The value of the variable corresponding to the global status. |
Sample query
Query the global server status variables and their corresponding values in OceanBase Database.
obclient [oceanbase]> SELECT * FROM information_schema.GLOBAL_STATUS;
The query result is as follows:
+-------------------+----------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+-------------------+----------------+
| Threads_connected | 1 |
| Uptime | 254110 |
+-------------------+----------------+
2 rows in set