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)銷策劃等。多年來(lái)，我們專注于互聯(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ù)的客戶以成都為中心已經(jīng)輻射到松桃省份的部分城市，未來(lái)相信會(huì)繼續(xù)擴(kuò)大服務(wù)區(qū)域并繼續(xù)獲得客戶的支持與信任！

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: `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 }`
`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: `STOPPED` `STARTED` `FAILED` - Archiver failed to archive a log last time but will try again within 5 minutes
`LOG_SWITCH_WAIT`	`VARCHAR2(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
`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: `ACTIVE` `SUSPENDED` `INSTANCE RECOVERY`
`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: `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.
`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: `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_MODE`	`VARCHAR2(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
`EDITION`	`VARCHAR2(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
`FAMILY`	`VARCHAR2(80)`	For internal use only.

新聞名稱：V$INSTANCE視圖
路徑分享：http://www.rwnh.cn/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開發(fā)

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

猜你還喜歡下面的內(nèi)容

中文字幕日韩精品一区二区免费_精品一区二区三区国产精品无卡在_国精品无码专区一区二区三区_国产αv三级中文在线

V$INSTANCE視圖

V$INSTANCE