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 applicable only to OceanBase Database in Oracle-compatible 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 IP 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)