mutex compare latch
oracle10g引入了mutexes的概念
mutexes和latch有部分相似處
latch 和 mutexes在機制上都是一個序列概念,但是mutex在使用上比latch更加輕量級別
簡單理解
latch可以保護多個物件,當要訪問latch保護的物件時,latch本身也有可能成為一個爭用的物件
mutexes相對來說處理比較靈活,在訪問對應物件時,mutexes會衍生一個新的mutex針對要保護的物件
多個session可以共享的使用一個mutex(Shared),單個session也可以獨佔的使用一個mutex(eXclusive)
In 10.2, the only client of mutexes is kks (Kernel Kompile Shared)
i.e. the shared cursor component of the library cache.
In future releases, other clients may also start using mutexes
·In 10.2.0.1, the mutex code path for pin replacement is only activated
when _kks_use_mutex_pin is set to true (in 10.2.0.2+, this is the default).
When this code path is in effect, library cache pins are not used,
and so the 'library cache pin*' related wait events will not be seen[@more@]
mutexes和latch有部分相似處
latch 和 mutexes在機制上都是一個序列概念,但是mutex在使用上比latch更加輕量級別
簡單理解
latch可以保護多個物件,當要訪問latch保護的物件時,latch本身也有可能成為一個爭用的物件
mutexes相對來說處理比較靈活,在訪問對應物件時,mutexes會衍生一個新的mutex針對要保護的物件
多個session可以共享的使用一個mutex(Shared),單個session也可以獨佔的使用一個mutex(eXclusive)
In 10.2, the only client of mutexes is kks (Kernel Kompile Shared)
i.e. the shared cursor component of the library cache.
In future releases, other clients may also start using mutexes
·In 10.2.0.1, the mutex code path for pin replacement is only activated
when _kks_use_mutex_pin is set to true (in 10.2.0.2+, this is the default).
When this code path is in effect, library cache pins are not used,
and so the 'library cache pin*' related wait events will not be seen[@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/48010/viewspace-1022822/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- mutex,latch,lock,enqueue hash chains latch基礎概念MutexENQAI
- compare databaseDatabase
- oracle mutexOracleMutex
- Oracle Latch及latch衝突Oracle
- Java Date CompareJava
- 體驗mutexMutex
- [20210520]11g shared pool latch與library cache mutex的簡單探究.txtMutex
- [20210521]11g shared pool latch與library cache mutex的簡單探究4.txtMutex
- Oracle KSL Latch 管理層 與 Latch管理Oracle
- Oracle:cursor:mutex XOracleMutex
- Oracle Mutex 等待事件OracleMutex事件
- [20210520]11g shared pool latch與library cache mutex的簡單探究3.txtMutex
- 'cursor:mutex ..'/ 'cursor:pin ..'/ 'library cache:mutex ..'型別的等待事件Mutex型別事件
- cbc latch或cache buffer chains latch系列一AI
- oracle 11g latch之v$latch系列二Oracle
- oracle 11g latch之v$latch系列三Oracle
- 中文Beyond Compare 4啟用安裝包+Beyond Compare 4金鑰
- Oracle Latch & LockOracle
- ABAP 程式比對(Compare)
- File Compare Utility 3.0.002
- Beyond Compare 5 記錄
- _gcry_ath_mutex_lock: Assertion `*lock == ((ath_mutex_t) 0)' failed.GCMutexAI
- Identify Which Latch is Associated with a "latch free" wait-413942.1IDEAI
- 當 Go struct 遇上 MutexGoStructMutex
- cursor: mutex S等待事件Mutex事件
- C#互斥體——MutexC#Mutex
- 【轉】spin lock 和mutexMutex
- CAS 演算法 —— Compare and Swap演算法
- compare用法示例•選項摘要
- ubuntu 命令安裝 beyond compareUbuntu
- How does Guice compare to Spring ?GUISpring
- ORACLE LOCK,LATCH,PINOracle
- Oracle Latch 說明Oracle
- [Oracle Script] check latchOracle
- 【筆記】lock and latch筆記
- latch free等待事件事件
- oracle latch優化Oracle優化
- latch入門?(最新更新part4:這才是真正的latch)---你所不知道的latch