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 | Indicates the login mode of the instance. Valid values: ALLOWED indicates that all users are allowed to log in. RESTRICTED indicates that only users with administrator privileges are allowed to log in.
NoteThis column is available starting with V4.4.2 BP1. |
| 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)