您好,登錄后才能下訂單哦!
V$INSTANCE
展示當(dāng)前實力的狀態(tài)。
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. |
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進行舉報,并提供相關(guān)證據(jù),一經(jīng)查實,將立刻刪除涉嫌侵權(quán)內(nèi)容。