Chapter 17. Shared Memory Contention

Oracle uses shared memory in the System Global Area (SGA) to improve performance by caching frequently accessed data in the buffer cache, reducing the amount of disk IO required to access that data. Oracle maintains other caches in the SGA as well, such as the redo log buffer, which buffers IO to the redo log files. Chapter 2, “Oracle Architecture and Concepts,” provides a review of the components and architecture of the SGA.

We look at how to configure these areas of memory to optimize performance in Chapter 18, “Buffer Cache Tuning,” and Chapter 20, “Other Memory Management Topics.” In this chapter we look at how contention for shared memory, the buffer cache in particular, can restrict SQL processing and ...

Get Oracle now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.