- ºÐ·ùÀ§Ä¡ >> DB >> ORACLE >> ±âŸ >>
|
|
Á¦¸ñ : Practical OWI in Oracle 10g(±×¸²À¸·Î ¸íÄèÇÏ°Ô Ç®¾î¾´) |
»õÃ¥Á¤°¡ : 35,000¿ø |
ÆǸŰ¡°Ý : 18,000¿ø |
ISBN : 9788995765333 |
ÃâÆÇÀÏ : - |
Àú ÀÚ : ÆíÁýºÎ |
ÃâÆÇ»ç : ¿¢¼À |
Ã¥»óÅ : AA±Þ(±¸ÀÔÈÄ °ÅÀǺ»Àû¾ø´Â »õÃ¥) |
ÆǸŰ¡´É±Ç(Áú)¼ö: 0 ±Ç(Áú) |
|
¹è¼Û¿ä±Ý : 0¿ø / ¹è¼Ûºñ ÆǸÅÀںδã(¹«·á¹è¼Û) |
¹è¼Û¹æ¹ý : Åùè¹è¼Û |
¹ÝÇ°¿©ºÎ : ¹ÝÇ°ºÒ°¡ |
¡¡ |
ÆǸŰ¡´ÉÁö¿ª : Àü±¹(Á¦ÁÖ,µµ¼Áö¿ªÁ¦¿Ü) |
ÆǸÅÀÚÁ¤º¸(ID / ÆǸŵî±Þ) : holsu83[
]
/ (Æò¹Î) |
|
|
(ÆǸſϷá) |
|
ÆǸÅÀÚ Ã¥»óÅ ¼³¸í :
¸î¹ø ÆîÃÄ º¸Áö ¾ÊÀº °ÅÀÇ »õÃ¥ ÀÔ´Ï´Ù.
DBA °ü·Ã °øºÎÇϽô ºÐ¿¡°Õ ¸¹Àº µµ¿ò µÇ´Â Ã¥ÀÔ´Ï´Ù.
Áö±Ý »õÃ¥ ±¸¸ÅÇϼŵµ 30,000¿ø ÀÌ»óÀº... |
¢Ñ
ÆǸÅÀÚ¿Í °¡°Ý Á¶Á¤À» ¿øÇϽøé ÂÊÁö ¶Ç´Â ´ñ±ÛÀ» ÀÌ¿ëÇØ º¸¼¼¿ä.
¢Ñ
´ñ±Û¾²±â(ÇöÀç 0 /
500byte):
´ñ±ÛÀº ÂÊÁö¿Í ¸ÞÀϷεµ
ÆǸÅÀÚ¿¡°Ô ÀÚµ¿¹ß¼Û µÇ¾î Æí¸® ÇÕ´Ï´Ù.
|
|
|
³» ¿ë : |
¿¢¼ÀÀº 2007³â 1¿ùºÎÅÍ ¿À¶óŬÀÇ Áö½Ä°ú °æÇèÀ» ü°èÈÇÑ 'Practical OWI in Oracle 10g'¶ó´Â ±³À° ÇÁ·Î±×·¥À» ÁøÇàÇÏ°í ÀÖ´Ù. ÀÌ ±³À°¿¡¼´Â ¿À¶óŬ¿¡ ´ëÇÑ »õ·Ó°í »ó¼¼ÇÑ À̾߱⸦ Àü´ÞÇϱâ À§ÇØ ³ë·ÂÇÑ´Ù. ±³À° ±³Àç¿¡¼ »ç¿ëÇß´ø ´Ù¾çÇÏ°í »ó¼¼ÇÑ ±×¸²À» ±×´ë·Î »ç¿ëÇØ ½Ã°¢Àû È¿°ú¸¦ ³ôÀÌ°í, »ó¼¼ÇÑ ¼³¸íÀ» ÅëÇØ ÃÖ´ëÇÑ ±×¸²¿¡ ´ëÇÑ ÀÌÇظ¦ µ½µµ·Ï Çß´Ù.
Latch¿Í LockÀÇ °³³ä, Buffer CacheÀÇ ¼º´É ¹®Á¦¿Í ´ë±â Çö»ó, Shared Pool / Library CacheÀÇ ¼º´É ¹®Á¦¿Í ´ë±â Çö»ó, Logical / Physical I/O¿¡¼ÀÇ ¼º´É ¹®Á¦¿Í ´ë±â Çö»ó, Transaction / Redo¿¡¼ÀÇ ¼º¹® ¹®Á¦¿Í ´ë±â Çö»ó, RAC¿¡¼ÀÇ ¼º´É ¹®Á¦¿Í ´ë±â Çö»óÀ» ¼³¸íÇÑ´Ù. |
¸ñ Â÷ : |
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
|
±â Ÿ : |
|
|