V$INSTANCE視圖

V$INSTANCE

V$INSTANCE 展示當(dāng)前實(shí)力的狀態(tài)。

創(chuàng)新互聯(lián)公司服務(wù)項(xiàng)目包括松桃網(wǎng)站建設(shè)、松桃網(wǎng)站制作、松桃網(wǎng)頁(yè)制作以及松桃網(wǎng)絡(luò)營(yíng)銷(xiāo)策劃等。多年來(lái)，我們專(zhuān)注于互聯(lián)網(wǎng)行業(yè)，利用自身積累的技術(shù)優(yōu)勢(shì)、行業(yè)經(jīng)驗(yàn)、深度合作伙伴關(guān)系等，向廣大中小型企業(yè)、政府機(jī)構(gòu)等提供互聯(lián)網(wǎng)行業(yè)的解決方案，松桃網(wǎng)站推廣取得了明顯的社會(huì)效益與經(jīng)濟(jì)效益。目前，我們服務(wù)的客戶(hù)以成都為中心已經(jīng)輻射到松桃省份的部分城市，未來(lái)相信會(huì)繼續(xù)擴(kuò)大服務(wù)區(qū)域并繼續(xù)獲得客戶(hù)的支持與信任！

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

See Also: "INSTANCE_NUMBER"

INSTANCE_NAMEVARCHAR2(16)Name of the instance
HOST_NAMEVARCHAR2(64)Name of the host machine
VERSIONVARCHAR2(17)Database version
STARTUP_TIMEDATETime when the instance was started
STATUSVARCHAR2(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 instance
ARCHIVERVARCHAR2(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 mounted
ACTIVE_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.

新聞名稱(chēng)：V$INSTANCE視圖
路徑分享：http://bm7419.com/article24/jdcsje.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站內(nèi)鏈、網(wǎng)站設(shè)計(jì)、網(wǎng)站導(dǎo)航、企業(yè)建站、網(wǎng)站收錄、App開(kāi)發(fā)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶(hù)投稿、用戶(hù)轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀(guān)點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話(huà)：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)

商城網(wǎng)站建設(shè)