[Oracle 만화] Aster~와 함께하는 Oracle Event Tour

ProDBA 카페에 [엑셈] 보물창고에서 가져온 캡처본으로 모든 저작권은 엑셈에 있습니다.

https://www.ex-em.com/

Data Artist Group - 엑셈

만화로 보는 오라클 튜닝 책에서 더 자세한 내용을 확인할 수 있습니다.

https://search.shopping.naver.com/book/catalog/32436109750?query=%EC%97%91%EC%85%88&NaPm=ct%3Dl7r9kpmo%7Cci%3D304150244f1e75468489b4dbdd62cc9289188286%7Ctr%3Dboksl%7Csn%3D95694%7Chk%3D7517c4572179d559b2441fe79bb73b4fddaf111c

만화로 보는 오라클 튜닝 : 네이버 도서

 

Scene 1. 동일 Row 변경에 의한 TX Enqueue

Scene 2. SQL의 파싱

Scene 3. SQL의 작성 

Scene 4. Enq: SQ - Contention

Scene 5. Latch: Cache Buffers Chains

Scene 6. Multi Block I/O

Scene 7. db file sequential read

Scene 8. Enq: US- Contention

Scene 9. Log File Sync

Scene 10. Library Cache Pin

Scene 11. Log Buffer Space

Scene 12. Read By Other Session

Scene 13. Direct Path Read Temp

 

Scene 14. Direct Path Write

Scene 15. Write Complete Waits

Scene 16. latch: Cache Buffers LRU Chain

Scene 17. Enq: TM-contention

Scene 18. latch:shared pool(Bind mismatch)

Scene 19. Enq: TX-index contention

Scene 20. latch: library cache(Function call로 인한 수행 횟수 증가)

Scene 21. log file switch completion

Scene 22. Enq:HW-Contention

Scene 23. gc buffer busy

Scene 24. Free buffer waits

Scene 25. SGA: allocation forcing component growth

 

Scene 26. Enq:TC-Contention

Scene 27. gc cr / current block 2/3-way

Scene 28. gc/cr current block congested

 

Scene 29. db file parallel write

Scene 30. db file parallel read

.

.

.

Scene 37. Enq: TX-allocate ITL entry

Scene 38. kksfbc child completion

.

.

.

Scene 40. Control file parallel write