Feature
This view displays the status of the current database instance.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Fields
Field |
Type |
Nullable |
Description |
|---|---|---|---|
| INST_ID | NUMBER | NO | The ID of the database instance. |
| INSTANCE_NUMBER | NUMBER | NO | The instance number for instance registration. At present, this field is not supported and is NULL by default. |
| INSTANCE_NAME | VARCHAR2(16) | NO | The name of the instance. At present, this field is not supported and is NULL by default. |
| HOST_NAME | VARCHAR2(64) | NO | The address of the server where the instance is located. |
| VERSION | VARCHAR2(17) | NO | The version of the database instance. |
| STARTUP_TIME | DATE | NO | The time when the instance was started. At present, this field is not supported and is NULL by default. |
| STATUS | VARCHAR2(12) | NO | The status of the instance. At present, this field is not supported and is NULL by default. |
| PARALLEL | VARCHAR2(3) | NO | Indicates whether the instance is mounted to a cluster database (YES) or not (NO). At present, this field is not supported and is NULL by default. |
| THREAD# | NUMBER | NO | The number of the redo thread. At present, this field is not supported and is NULL by default. |
| ARCHIVER | VARCHAR2(7 | NO | The log archiving status of the archiver. Valid values: |
| LOG_SWITCH_WAIT | VARCHAR2(15) | NO | The event that log switching is waiting for. At present, this field is not supported and is NULL by default. |
| LOGINS | VARCHAR2(10) | NO | |
| SHUTDOWN_PENDING | VARCHAR2(3) | NO | The value is YES or NO. At present, this field is not supported and is NULL by default. |
| DATABASE_STATUS | VARCHAR2(17) | NO | The status of the database. |
| INSTANCE_ROLE | VARCHAR2(18) | NO | The role of the instance. Valid values: |
| ACTIVE_STATE | VARCHAR2(9) | NO | The quiesce state of the instance. At present, this field is not supported and is NULL by default. |
| BLOCKED | VARCHAR2(2) | NO | Indicates whether all requests are blocked. Valid values: |
| CON_ID | NUMBER | NO | The ID of the container where the data is located. At present, this field is not supported and is NULL by default. |
| INSTANCE_MODE | VARCHAR2(11) | NO | The mode of the instance. Valid values: |
| EDITION | VARCHAR2(7) | NO | The commercial edition of the instance. At present, this field is not supported and is NULL by default. |
| FAMILY | VARCHAR2(80) | NO | For internal use only. At present, this field is not supported and is NULL by default. |
| DATABASE_TYPE | VARCHAR2(15) | NO | The type of the database instance. At present, this field is not supported and is NULL by default. |