http://blog.csdn.net/wyzxg/article/details/4728622
author:skate
time:2009-10-26
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:
|
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. |