latch: enqueue hash chains
enq: TX - row lock contention
enq: TX - index contention
enq: TX - contention
enq: HW - contention
enq: FB - contention
enq: SQ - contention
enqueue latch
enq:XX 队列锁等待,视乎不同的队列锁有不同的情况:
- 你有多了解Oracle Enqueue lock队列锁机制?
- Oracle队列锁: Enqueue HW
- Oracle队列锁enq:US,Undo Segment
- enq: TX – row lock/index contention、allocate ITL等待事件
- enq: TT – contention等待事件
- Oracle队列锁enq:TS,Temporary Segment (also TableSpace)
- enq: JI – contention等待事件
- enq: US – contention等待事件
- enq: TM – contention等待事件
- enq: RO fast object reuse等待事件
- enq: HW – contention等待事件