Note
This view is available starting with V2.2.77.
Purpose
This view displays the status of the current database instance.
Applicability
This view is available only for OceanBase Database in Oracle mode.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| INST_ID | NUMBER | NO | The ID of the database instance. |
| INSTANCE_NUMBER | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| INSTANCE_NAME | VARCHAR2(16) | NO | This column is not supported. The value of this column 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 | This column is not supported. The value of this column is NULL by default. |
| STATUS | VARCHAR2(12) | NO | This column is not supported. The value of this column is NULL by default. |
| PARALLEL | VARCHAR2(3) | NO | This column is not supported. The value of this column is NULL. |
| THREAD# | NUMBER | NO | This column is not supported. The value of this column is NULL. |
| ARCHIVER | VARCHAR2(7) | NO | This column is not supported. The value of this column is NULL. |
| LOG_SWITCH_WAIT | VARCHAR2(15) | NO | This column is not supported. The value of this column is NULL. |
| LOGINS | VARCHAR2(10) | NO | This column is not supported. The value of this column is NULL. |
| SHUTDOWN_PENDING | VARCHAR2(3) | NO | This column is not supported. The value of this column is NULL. |
| DATABASE_STATUS | VARCHAR2(17) | NO | The status of the database. |
| INSTANCE_ROLE | VARCHAR2(18) | NO | This column is not supported. The value of this column is NULL. |
| ACTIVE_STATE | VARCHAR2(9) | NO | This column is not supported. The value of this column is NULL. |
| BLOCKED | VARCHAR2(2) | NO | This column is not supported. The value of this column is NULL. |
| CON_ID | NUMBER | NO | This column is not supported. The value of this column is NULL. |
| INSTANCE_MODE | VARCHAR2(11) | NO | This column is not supported. The value of this column is NULL. |
| EDITION | VARCHAR2(7) | NO | This column is not supported. The value of this column is NULL. |
| FAMILY | VARCHAR2(80) | NO | This column is not supported. The value of this column is NULL. |
| DATABASE_TYPE | VARCHAR2(15) | NO | This column is not supported. The value of this column is NULL. |
Sample query
Query the status of the current database instance.
obclient [SYS]> SELECT * FROM SYS.V$INSTANCE\G
The query result is as follows:
*************************** 1. row ***************************
INST_ID: 1
INSTANCE_NUMBER: NULL
INSTANCE_NAME: NULL
HOST_NAME: xx.xx.xx.xx:28825
VERSION: xxxxx
STARTUP_TIME: NULL
STATUS: NULL
PARALLEL: NULL
THREAD#: NULL
ARCHIVER: NULL
LOG_SWITCH_WAIT: NULL
LOGINS: NULL
SHUTDOWN_PENDING: NULL
DATABASE_STATUS: ACTIVE
INSTANCE_ROLE: NULL
ACTIVE_STATE: NULL
BLOCKED: NULL
CON_ID: NULL
INSTANCE_MODE: NULL
EDITION: NULL
FAMILY: NULL
DATABASE_TYPE: NULL
1 row in set (0.052 sec)