Practical OWI in Oracle 10g

CHAPTER 1. Latch & Lock
- Latch 개요
- Latch free
- Lock 개요
- Enqueue
- Lock 관련 Event

CHAPTER 2. Row Cache & OWI
- Row Cache 개요
- row cache lock
- enq : SQ-contention

CHAPTER 3. Shared Pool & OWI
- Shared Pool 개요
- Shared Pool 구성요소
- SQL 실행
- latch : library cache
- Shared Pool 관련 Latch
- latch : shared pool
- Shared Pool 관련 Lock
- Library cache lock / Library cache pin

CHAPTER 4. Cache Buffer & OWI
- Cache Buffer
- latch : cache buffers chains
- Touch Count Based Algorithm
- latch : cache buffers lru chain
- Multiple Buffer Pool
- Logical I/O
- Buffer Lock
- buffer busy waits
- Read by other session
- Write complete waits

CHAPTER 5. I/O & OWI
- Oracle I/O
- db file sequential read
- db file scattered read
- direct path read / write
- direct path read / write temp

CHAPTER 6. Read & OWI
- Redo 개요
- Commit 개요
- Commit Mechanism
- Log file sync
- Log buffer space

CHAPTER 7. Transaction & OWI
- Transaction 개요
- Transaction 처리
- Lock 개요
- TX Lock
- TM Lock

CHAPTER 8. RAC & OWI
- RAC 개념
- Global Cache 동기화
- Cluster Event 구조 (개별 대기 이벤트들)
- Global Cache Event와 통계값
- Global Lock 동기화
- RAC 성능
- RAC 성능 : FLM vs ASSM
- RAC 성능 : Sequence Cache
- RAC 성능 : Dynamic Resource Remastering
- RAC 성능 : Dynamic Performance Views