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. |
