Overview
V$INSTANCE displays the status of the current database instance.
Field description
| Field name | 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: At present, this field is not supported and is NULL by default. |
| 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 | At present, this field is not supported and is NULL by default. |
| SHUTDOWN_PENDING | VARCHAR2(3) | 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: At present, this field is not supported and is NULL by default. |
| 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 | Whether all requests are blocked At present, this field is not supported and is NULL by default. |
| 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: At present, this field is not supported and is NULL by default. |
| 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. |
