V$INSTANCE

V$INSTANCE 展示当前实力的状态。

ColumnDatatypeDescriptionINSTANCE_NUMBERNUMBERInstance number used for instance registration (corresponds to the INSTANCE_NUMBER initialization parameter)

See Also: "INSTANCE_NUMBER"

INSTANCE_NAMEVARCHAR2(16)Name of the instanceHOST_NAMEVARCHAR2(64)Name of the host machineVERSIONVARCHAR2(17)Database versionSTARTUP_TIMEDATETime when the instance was startedSTATUSVARCHAR2(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 }

PARALLELVARCHAR2(3)Indicates whether the instance is mounted in cluster database mode (YES) or not (NO)THREAD#NUMBERRedo thread opened by the instanceARCHIVERVARCHAR2(7)Automatic archiving status:

STOPPED

STARTED

FAILED - Archiver failed to archive a log last time but will try again within 5 minutes

LOG_SWITCH_WAITVARCHAR2(15)Event that log switching is waiting for:

ARCHIVE LOG

CLEAR LOG

CHECKPOINT

NULL - ALTER SYSTEM SWITCH LOGFILE is hung but there is room in the current online redo log

LOGINSVARCHAR2(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_PENDINGVARCHAR2(3)Indicates whether a shutdown is pending (YES) or not (NO)DATABASE_STATUSVARCHAR2(17)Status of the database:

ACTIVE

SUSPENDED

INSTANCE RECOVERY

INSTANCE_ROLEVARCHAR2(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 mountedACTIVE_STATEVARCHAR2(9)Quiesce state of the instance:

NORMAL - Database is in a normal state.

QUIESCING - ALTER SYSTEM QUIESCE RESTRICTED 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 - ALTER SYSTEM QUIESCE RESTRICTED 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.

A single ALTER SYSTEM QUIESCE RESTRICTED statement quiesces all instances in an Oracle RAC 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.

BLOCKEDVARCHAR2(3)Indicates whether all services are blocked (YES) or not (NO)CON_IDNUMBERThe ID of the container to which the data pertains. Possible values include:

0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

1: This value is used for rows containing data that pertain to only the root

n: Where n is the applicable container ID for the rows containing data

INSTANCE_MODEVARCHAR2(11)Mode of the Oracle Real Application Clusters (Oracle RAC) instance.

Possible values:

REGULAR: A regular Oracle RAC instance

READ MOSTLY: An Oracle RAC instance which has very few database writes

EDITIONVARCHAR2(7)The edition of the database.

Possible values include:

CORE EE: CORE Enterprise Edition

CORE SE: CORE Standard Edition

EE: Enterprise Edition

PO: Personal Edition

SE: Standard Edition

XE: Express Edition

FAMILYVARCHAR2(80)For internal use only.