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:
|
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 ).
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. |