oracle enqueue type
This appendix lists Oracle enqueues. Enqueues are shared memory structures (locks) that serialize access to database resources. They can be associated with a session or transaction. Enqueue names are displayed in the LOCK_TYPE column of the DBA_LOCK and DBA_LOCK_INTERNAL data dictionary views.
A resource uniquely identifies an object that can be locked by different sessions within an instance (local resource) or between instances (global resource). Each session that tries to lock the resource will have an enqueue on the resource.
Note:
The names of enqueues and their definitions may change from release to release.The Oracle enqueues are:
-
FP, File Object
-
KO, Multiple Object Checkpoint
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/756652/viewspace-464441/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle enqueue(zt)OracleENQ
- oracle enqueue lockOracleENQ
- Oracle Enqueue WaitsOracleENQAI
- Oracle enqueue wait tipsOracleENQAI
- ORACLE 中的Enqueue 種類OracleENQ
- oracle block type!OracleBloC
- Oracle 11g Enqueue Waits DescOracleENQAI
- Oracle ebs patch typeOracle
- Oracle 9i RAC enqueue等待測試OracleENQ
- TC ENQUEUEENQ
- 【ASK_ORACLE】Row Cache Enqueue鎖之概念篇OracleENQ
- Oracle Global Enqueue Services Deadlock detected錯誤詳解OracleENQ
- enqueue種類ENQ
- oracle plsql(三)_type_cursorOracleSQL
- ORACLE中%TYPE和%ROWTYPE的使用Oracle
- oracle patch補丁型別typeOracle型別
- 上傳enqueue剖析ENQ
- 什麼是enqueueENQ
- enqueue wait event .ENQAI
- Statspack之十三-EnqueueENQ
- Enqueue events part oneENQ
- Enqueue events part twoENQ
- What is the "WF - Contention'' Enqueue ?ENQ
- Enqueue 鎖定機制ENQ
- ENQUEUE總結筆記ENQ筆記
- TX ENQUEUE阻塞的理解ENQ
- Enqueue整理總結(轉)ENQ
- enqueue的種類(zt)ENQ
- 又見enqueue(TM SRX)ENQ
- 關於Oracle 9i RAC enqueue等待的一點測試OracleENQ
- 9i,enqueue,ORACLE鎖爭用 檢視爭用型別ENQOracle型別
- Oracle10g stream : :dml.get_command_type and lcr.get_command_typeOracle
- Oracle constraints type 約束型別OracleAI型別
- GLOBAL ENQUEUE SERVICES DEADLOCK DETECTEDENQ
- 確定enqueue鎖型別ENQ型別
- enable table lock 的enqueue等待ENQ
- variable: Type 與 Type variable
- cannot convert (type interface {}) to type int: need type assertion