V $ INSTANCE

此视图显示当前实例的状态。

柱	数据类型	描述
INSTANCE_NUMBER	NUMBER	用于实例注册的实例编号（对应于INSTANCE_NUMBER初始化参数） 另请参阅： “INSTANCE_NUMBER”
INSTANCE_NAME	VARCHAR2(16)	实例的名称
HOST_NAME	VARCHAR2(64)	主机名称
VERSION	VARCHAR2(17)	数据库版本
STARTUP_TIME	DATE	实例启动的时间
STATUS	VARCHAR2(12)	实例的状态： STARTED - 之后 STARTUP NOMOUNT MOUNTED- 之后STARTUP MOUNT或ALTER DATABASE CLOSE OPEN- 之后STARTUP或ALTER DATABASE OPEN OPEN MIGRATE - 之后 ALTER DATABASE OPEN { UPGRADE | DOWNGRADE }
PARALLEL	VARCHAR2(3)	指示实例是以群集数据库模式（YES）安装还是不安装（NO）
THREAD#	NUMBER	由实例打开的重做线程
ARCHIVER	VARCHAR2(7)	（STOPPED| STARTED| FAILED）FAILED表示归档器上次无法归档日志，但会在5分钟内再次尝试
LOG_SWITCH_WAIT	VARCHAR2(11)	该ARCHIVE LOG/ CLEAR LOG/ CHECKPOINT事件日志切换等待。请注意，如果ALTER SYSTEM SWITCH LOGFILE挂起，但当前在线重做日志中有空间，则值为NULL
LOGINS	VARCHAR2(10)	ALLOWED | RESTRICTED
SHUTDOWN_PENDING	VARCHAR2(3)	YES | NO
DATABASE_STATUS	VARCHAR2(17)	数据库的状态
INSTANCE_ROLE	VARCHAR2(18)	描述实例是活动实例（PRIMARY_INSTANCE）还是非活动辅助实例（SECONDARY_INSTANCE），或者UNKNOWN实例是否已启动但未安装
ACTIVE_STATE	VARCHAR2(9)	(NORMAL|QUIESCING|QUIESCED). NORMAL 表示数据库处于正常状态。 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. 请注意，单个ALTER SYSTEM QUIESCE RESTRICTED语句将停止Real Application Clusters环境中的所有实例。在发出此语句之后，某些实例可能会在其他实例之前进入静默状态; 当所有实例进入静止状态时，系统处于静默状态。