Note
This view is introduced since OceanBase Database V1.4.
Purpose
This view displays the global status information about OceanBase Database.
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