Dynamic Performance (V$) Views, 68 of 179

V$INSTANCE

This view displays the state of the current instance. This version of V$INSTANCE is not compatible with earlier versions of V$INSTANCE.

Column Datatype Description

INSTANCE_NUMBER

NUMBER

Instance number used for instance registration. Corresponds to INSTANCE_NUMBER initialization parameter
See "INSTANCE_NUMBER"

INSTANCE_NAME

VARCHAR2(16)

Instance name

HOST_NAME

VARCHAR2(64)

Name of the host machine

VERSION

VARCHAR2(17)

RDBMS version

STARTUP_TIME

DATE

Time when instance was started up

STATUS

VARCHAR2(7)

STARTED/MOUNTED/OPEN
STARTED after startup nomount
MOUNTED after startup mount or alter database close
OPEN after startup or after database open

PARALLEL

VARCHAR2(3)

YES/NO in parallel server mode

THREAD#

NUMBER

Redo thread opened by the instance

ARCHIVER

VARCHAR2(7)

STOPPED | STARTED | FAILED. FAILED means that the archiver failed to archive a log last time, but will try again within 5 minutes

LOG_SWITCH_WAIT

VARCHAR2(11)

ARCHIVE LOG/CLEAR LOG/CHECKPOINT event log switching is waiting for. Note that if ALTER SYSTEM SWITCH LOGFILE is hung, but there is room in the current online redo log, then value is NULL

LOGINS

VARCHAR2(10)

ALLOWED/RESTRICTED

SHUTDOWN_PENDING

VARCHAR2(3)

YES/NO

DATABASE_STATUS

VARCHAR2(17)

The status of the database

INSTANCE_ROLE

VARCHAR2(16)

Describes whether the instance is an active instance (PRIMARY_INSTANCE) or a inactive secondary instance (SECONDARY_INSTANCE), or UNKNOWN if the instance has been started but not mounted.

Note: SECONDARY_INSTANCE is displayed only if your cluster has just two instances and you have set the ACTIVE_INSTANCE_COUNT initialization parameter to 1.

Column	Datatype	Description
`INSTANCE_NUMBER`	`NUMBER`	Instance number used for instance registration. Corresponds to INSTANCE_NUMBER initialization parameter See "INSTANCE_NUMBER"
`INSTANCE_NAME`	`VARCHAR2(16)`	Instance name
`HOST_NAME`	`VARCHAR2(64)`	Name of the host machine
`VERSION`	`VARCHAR2(17)`	RDBMS version
`STARTUP_TIME`	`DATE`	Time when instance was started up
`STATUS`	`VARCHAR2(7)`	STARTED/MOUNTED/OPEN STARTED after startup nomount MOUNTED after startup mount or alter database close OPEN after startup or after database open
`PARALLEL`	`VARCHAR2(3)`	YES/NO in parallel server mode
`THREAD#`	`NUMBER`	Redo thread opened by the instance
`ARCHIVER`	`VARCHAR2(7)`	STOPPED \| STARTED \| FAILED. FAILED means that the archiver failed to archive a log last time, but will try again within 5 minutes
`LOG_SWITCH_WAIT`	`VARCHAR2(11)`	ARCHIVE LOG/CLEAR LOG/CHECKPOINT event log switching is waiting for. Note that if ALTER SYSTEM SWITCH LOGFILE is hung, but there is room in the current online redo log, then value is NULL
`LOGINS`	`VARCHAR2(10)`	ALLOWED/RESTRICTED
`SHUTDOWN_PENDING`	`VARCHAR2(3)`	YES/NO
`DATABASE_STATUS`	`VARCHAR2(17)`	The status of the database
`INSTANCE_ROLE`	`VARCHAR2(16)`	Describes whether the instance is an active instance (PRIMARY_INSTANCE) or a inactive secondary instance (SECONDARY_INSTANCE), or UNKNOWN if the instance has been started but not mounted.
		Note: SECONDARY_INSTANCE is displayed only if your cluster has just two instances and you have set the ACTIVE_INSTANCE_COUNT initialization parameter to 1.