OWI Basic Concepts
- OWI ±âº» °³³ä
- Latch vs. Lock
- OWIÀÇ ÇÔÁ¤
Parse and OWI
- Soft Parse vs. Hard Parse
- Latch Contention
- LCOÀÇ Aging Out ¹®Á¦
- Unshareable SQL
- CursorÀÇ °³³ä
- LCO Contention
- Cursor Invalidation ¹®Á¦
Reads on OWI
- Logical Reads vs. Physical Reads
- Latch Contention
- BufferÀÇ °³³ä
- Buffer Contention
- BufferÀÇ Aging Out ¹®Á¦
- Multiple Buffer Pool
- Single Block I/O vs. Multi Block I/O
- Index Maintenance and Single Block I/O
- Read Consistency and Single Block I/O
Transaction and OWI
- TransactionÀÇ °³³ä
- TM Lock vs. TX Lock
- Read Consistency
- Snapshot too old, delayed block cleanout
- Log file sync ¹®Á¦
- Online DDL°ú Transaction µ¿±âÈ ¹®Á¦
- Redo ÁÙÀ̱â
|