Á¦4Â÷ Oracle Performance in Depth
Oracle ¼º´É Æ©´×ÀÇ ¼¼°¡Áö Á¢±Ù¹æ¹ýÀÎ Index, CBO, OWI¸¦ ü°èÀûÀÌ°í ½ÇõÀûÀÎ Ä¿¸®Å§·³À» ÅëÇØ ½ÉµµÀÖ°í ½Ç¿ëÀûÀÎ Áö½ÄÀ» Àü´ÞÇÏ¿© DBAµéÀÇ ¼º´É¹®Á¦ ÇØ°á ´É·ÂÀ» Çâ»óµÇµµ·Ï µ½½À´Ï´Ù

OWI(Oracle Wait Interface)´Â Oracle ¼º´É ¹®Á¦¸¦ ÇØ¼®Çϰí Áø´ÜÇÏ´Â °¡Àå ÁÁÀº ¹æ¹ýÀÔ´Ï´Ù. OWI¸¦ ÅëÇÑ ´ë±â Çö»ó ºÐ¼®ÀÇ ±âÃÊ¿Í Parse, Reads(I/O), Transaction µî¿¡¼­ÀÇ ´ë±â Çö»ó Áø´Ü¿¡ ´ëÇÑ ½Éµµ±íÀº ³íÀǸ¦ ÁøÇàÇÕ´Ï´Ù.

ÀϽà : 2008³â 12¿ù 4ÀÏ ¸ñ¿äÀÏ ¿ÀÀü10½Ã~¿ÀÈÄ 5½Ã (ÃÑ 6½Ã°£)
Àå¼Ò : ¼­¿ï½Ã °­³²±¸ ¿ª»ïµ¿ 697-5 ¼­¿ïº¥Ã³Å¸¿ö(¾ÆÁÖºôµù) 19Ãþ Á¦ 1¼¼¹Ì³ª½Ç
Àοø : 40¸í
¼ö°­·á : \165,000¿ø
ÀԱݹæ¹ý : Á¦ÀÏÀºÇà 429-20-040766 ¢ß¿¢¼À

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 ÁÙÀ̱â

°­»ç : Á¶ µ¿¿í
(ÁÖ)¿¢¼À ±³À° ÄÁÅÙÃ÷ÆÀ ÆÀÀå / ¼ö¼®ÄÁ¼³ÅÏÆ®
±³À° : Oracle is Mad¢ç
Oracle Performance in Depth
OWI(Oracle Wait interface) Seminar
POWI(Practical Oracle Wait interface) Seminar
Oracle PSI ±³À°
Àú¼­ : Advanced Oracle Wait Interface in 10g
Internals and Performance in Oracle 10g RAC

* ¼¼¹Ì³ª¿¡ Âü¼®ÇϽô ¸ðµç ºÐ²²´Â ¾Æ½ºÅÍ ¸Ó±×ÄÅÀ» µå¸³´Ï´Ù.

(ÁÖ)¿¢¼À


Enqueue
¾ÆÁ÷Àº ¾î·Á¿î TStrin...
¿¢¼À ·¯ºêÇϿ콺, »õ...
[¿¬¸»Æ¯Áý] Àç¹Ì³ª°Ô ...
¿¢¼À ÀÌÀü ¾È³»
2009³â ¿¢¼À ±³À° ¼Ò°³
Á¦4Â÷ Oracle Performa...
»ó´ÜÀ¸·Î ¹Ù·Î°¡±â