【等待事件】ORACLE常見等待事件

常見等待事件

---Buffer cache

latch: cache buffers chains

latch: cache buffers lru chain

latch: cache buffer handles

buffer busy waits

buffer exterminate

read by other session

---shared pool

latch: shared pool

latch: library cache

latch: library cache lock

latch: library cache pin

--Dictionary Cache

row cache lock

enq: SQ – contention

 

--transaction

enq: TM – contention

enq: TX - row lock contention

enq: TX - allocate ITL entry

enq: TX - index contention

enq: TX – contention

enq: UL – contention

--Segment

enq: HW – contention

enq: ST – contention

enq: TT – contention

enq: US – contention

 

--IO

db file sequential read

db file scattered read

db file parallel write

db file parallel read

control file parallel write

direct path read

direct path read temp

direct path write

direct path write temp

--redo

log file sync

log file switch (checkpoint incomplete)

log file switch (private strand flush incomplete)

log file parallel write

log file switch (archiving needed)

log file switch completion

log file switch (clearing log file)

log buffer space

latch: redo allocation

latch: redo writing

latch: redo copy