Purpose
The GV$INSTANCE view displays the status of the current database instance.
Applicability
This view applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| INST_ID | NUMBER | NO | The ID of the database instance. |
| INSTANCE_NUMBER | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| INSTANCE_NAME | VARCHAR2(16) | NO | At present, this column is not supported and its value is NULL by default. |
| HOST_NAME | VARCHAR2(64) | NO | The address of the OBServer node where the instance resides. |
| VERSION | VARCHAR2(17) | NO | The version of the database instance. |
| STARTUP_TIME | DATE | NO | At present, this column is not supported and its value is NULL by default. |
| STATUS | VARCHAR2(12) | NO | At present, this column is not supported and its value is NULL by default. |
| PARALLEL | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| THREAD# | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| ARCHIVER | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| LOG_SWITCH_WAIT | VARCHAR2(15) | NO | At present, this column is not supported and its value is NULL by default. |
| LOGINS | VARCHAR2(10) | NO | At present, this column is not supported and its value is NULL by default. |
| SHUTDOWN_PENDING | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| DATABASE_STATUS | VARCHAR2(17) | NO | The status of the database. |
| INSTANCE_ROLE | VARCHAR2(18) | NO | At present, this column is not supported and its value is NULL by default. |
| ACTIVE_STATE | VARCHAR2(9) | NO | At present, this column is not supported and its value is NULL by default. |
| BLOCKED | VARCHAR2(2) | NO | At present, this column is not supported and its value is NULL by default. |
| CON_ID | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| INSTANCE_MODE | VARCHAR2(11) | NO | At present, this column is not supported and its value is NULL by default. |
| EDITION | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| FAMILY | VARCHAR2(80) | NO | At present, this column is not supported and its value is NULL by default. |
| DATABASE_TYPE | VARCHAR2(15) | NO | At present, this column is not supported and its value is NULL by default. |