이 상품은 구매 후 지원 기기에서 예스24 eBook앱 설치 후 바로 이용 가능한 상품입니다.
|
CHAPTER 1. Latch & Lock- Latch 개요- Latch free- Lock 개요- Enqueue- Lock 관련 EventCHAPTER 2. Row Cache & OWI- Row Cache 개요- row cache lock- enq : SQ-contentionCHAPTER 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 pinCHAPTER 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 waitsCHAPTER 5. I/O & OWI- Oracle I/O- db file sequential read- db file scattered read- direct path read / write- direct path read / write tempCHAPTER 6. Read & OWI- Redo 개요- Commit 개요- Commit Mechanism- Log file sync- Log buffer spaceCHAPTER 7. Transaction & OWI- Transaction 개요- Transaction 처리- Lock 개요- TX Lock- TM LockCHAPTER 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
|