'Library cache' presentation slideshows

Inside RAC

Inside RAC. Julian Dyke Independent Consultant. Web Version. juliandyke.com. Agenda. Introduction to RAC Memory Structures The Buffer Cache Global Cache Services The Library Cache Global Enqueue Services. Introduction to RAC. Node 1. Node 2. Instance 1. Instance 2. Interconnect.

1.23k views • 106 slides

Make a Real DBA

Make a Real DBA. ???? ??. ? ??????. ? ? ?. ???? ??. ??? ???? SGA ??? ?? ?? ??? ??? Latch ? Enqueue Q & A. ??? ???? SGA ??? ??. SGA ? ?? ??? ?? SGA ??? ??. System Global Area. Database Buffer Cache. Redo Log Buffer. Shared Pool. SHARED_POOL_SIZE. DB_CACHE_SIZE.

544 views • 52 slides

The Library Cache

The Library Cache. Objectives. At the end of this section, you should be able to: Explain the library cache architecture List locks, pins, and latches in the library cache Identify when library cache contention occurs Describe how to reduce library cache contention

762 views • 50 slides

Memory Management

Memory Management. Objectives. At the end of this section, you should be able to: Identify the different memory areas that are used by the Oracle server Explain how and when those areas are allocated Describe the architecture of a memory heap

581 views • 44 slides

Oracle9 i Performance Tuning

Oracle9 i Performance Tuning. Chapter 4 Tuning the Shared Pool Memory. Chapter Objectives. Understand the role of the Shared Pool Memory Learn Shared Pool Advice terms Learn terms for the internal structures of the Shared Pool Memory

600 views • 41 slides

Module 1 DBMS Strategy and ORACLE Architecture

513 views • 35 slides