O'Reilly logo

Oracle by Guy Harrison

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required