ADVANCED OWI IN ORACLE 10G

목차

I. OWI 소개 OWI란?

• OWI의 특징
• OWI 툴
• OWI 데이터 수집
• 기타

II. 래치(Latch)와 락(Lock)

• 오라클의 동기화 메커니즘
• 래치(Latch)
• 락(Lock)

III. 오라클 내부구조와 OWI

• 버퍼 캐시와 OWI
• Shared Pool, Library Cache와 OWI
• 트랜잭션과 OWI
• 세그먼트와 OWI
• IO와 OWI
• 리두와 OWI

IV. 버퍼 캐시(Buffer Cache)에서의 대기이벤트들

• latch - cache buffers chains
• latch - cache buffers lru chain
• buffer busy waits, read by other session
• Write complete waits I
• free buffer waits
• enq TC - contention
• enq CI - contention, enq RO - contention

V. Library Cache 에서의 대기이벤트들

• latch shared pool
• latch library cache

VI. Row Cache에서의 대기이벤트들

• row cache lock I
• enq SQ - contention, DFS lock handle(SV)

VII. 트랜잭션(Transaction)에서의 대기이벤트들

• enq TM - contention
• enq TX - row lock contention, enq TX - allocate ITL Entry, enq TX - index contention
• enq UL - contention, PLSQL lock Timer

VIII. 세그먼트(Segment)에서의 대기이벤트들

• enq HW - contention
• enq ST - contention, enq TT - contention
• enq US - contention

IX. I/O에서의 대기이벤트들

• db file scattered read
• db file sequential read
• direct path read
• direct path write
• direct path read temp, direct path write temp
• direct path read(lob)m direct path write(lob)
• db file parallel write
• control file parallel write

X. 리두(Redo)에서의 대기이벤트들

• latch - redo writing, latch - redo allocation, latch - redo copy
• log file sync
• log file parallel write
• log buffer space

XI. 네트웍(Network)에서의 대기이벤트들

• Network 관련 대기이벤트들