Chapter 20. Other Memory Management Topics

In the past two chapters, we’ve seen how to analyze the memory allocated to the PGA and the buffer cache and how to optimize each memory area for greatest effectiveness. Maximizing the memory within each of these areas is important, but getting the most out of your overall memory is impossible unless you allocate effectively between the two regions. In 11g, Oracle can manage the allocation of memory within the two regions automatically, whereas in 10g it’s up to you to determine the relative size of each region. Even in 11g, you might want to manually allocate memory to optimize for a specific workload rather than to allow Oracle to adjust memory continuously. We cover both techniques in this chapter. ...

Get Oracle now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.