V$INSTANCE视图
V$INSTANCE
V$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) |
Automatic archiving
status:
|
LOG_SWITCH_WAIT |
VARCHAR2(15) |
Event that log
switching is waiting for:
|
LOGINS |
VARCHAR2(10) |
Indicates whether the
instance is in unrestricted mode, allowing logins by all users (ALLOWED , or in restricted mode, allowing logins by database
administrators only (RESTRICTED ) |
SHUTDOWN_PENDING |
VARCHAR2(3) |
Indicates whether a
shutdown is pending (YES ) or not (NO ) |
DATABASE_STATUS |
VARCHAR2(17) |
Status of the database:
|
INSTANCE_ROLE |
VARCHAR2(18) |
Indicates 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) |
Quiesce state of the
instance:
A single |
BLOCKED |
VARCHAR2(3) |
Indicates whether all
services are blocked (YES ) or not (NO ) |
CON_ID |
NUMBER |
The ID of the container
to which the data pertains. Possible values include:
|
INSTANCE_MODE |
VARCHAR2(11) |
Mode of the Oracle Real
Application Clusters (Oracle RAC) instance. Possible values:
|
EDITION |
VARCHAR2(7) |
The edition of the
database. Possible values include:
|
FAMILY |
VARCHAR2(80) |
For internal use only. |