V$INSTANCE

This view displays the state of the current instance.

Column	Datatype	Description
`INSTANCE_NUMBER`	`NUMBER`	Instance number used for instance registration (corresponds to the `INSTANCE_NUMBER`initialization parameter) See Also: "INSTANCE_NUMBER"
`INSTANCE_NAME`	`VARCHAR2(16)`	Name of the instance
`HOST_NAME`	`VARCHAR2(64)`	Name of the host machine
`VERSION`	`VARCHAR2(17)`	Database version
`STARTUP_TIME`	`DATE`	Time when the instance was started
`STATUS`	`VARCHAR2(12)`	Status of the instance: `STARTED` - After `STARTUP NOMOUNT` `MOUNTED` - After `STARTUP MOUNT` or `ALTER DATABASE CLOSE` `OPEN` - After `STARTUP` or `ALTER DATABASE OPEN` `OPEN MIGRATE` - After `ALTER DATABASE OPEN { UPGRADE \| DOWNGRADE }`
`PARALLEL`	`VARCHAR2(3)`	Indicates whether the instance is mounted in cluster database mode (`YES`) or not (`NO`)
`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)`	The `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)`	Status of the database
`INSTANCE_ROLE`	`VARCHAR2(18)`	Describes whether the instance is an active instance (`PRIMARY_INSTANCE`) or an inactive secondary instance (`SECONDARY_INSTANCE`), or `UNKNOWN` if the instance has been started but not mounted
`ACTIVE_STATE`	`VARCHAR2(9)`	(`NORMAL\|QUIESCING\|QUIESCED`). `NORMAL` indicates the database is in a normal state. `QUIESCING` indicates that the `ALTER SYSTEM QUIESCE RESTRICTED` statement has been issued: no new user transactions, queries, or PL/SQL statements are processed in this instance. User transactions, queries, or PL/SQL statements issued before the `ALTER SYSTEM QUIESCE RESTRICTED` statement are unaffected. DBA transactions, queries, or PL/SQL statements are also unaffected. `QUIESCED` indicates that the `ALTER SYSTEM QUIESCE RESTRICTED` statement has been issued: no user transactions, queries, or PL/SQL statements are processed. DBA transactions, queries, or PL/SQL statements are unaffected. User transactions, queries, or PL/SQL statements issued after the `ALTER SYSTEM QUIESCE RESTRICTED`statement are not processed. Note that a single ALTER SYSTEM QUIESCE RESTRICTED statement quiesces all instances in a Real Application Clusters environment. After this statement has been issued, some instances may enter into a quiesced state before other instances; the system is quiesced when all instances enter the quiesced state.