Chapter 42

Diving into the Shared Pool

Michael R. Ault

Perhaps one of the least understood areas of Oracle Shared Global Area optimization is tuning the shared pool. The generally accepted tuning methodology involves throwing memory into the pool until the problem goes under. This chapter examines the shared pool and defines a method for tuning that uses measurement — not guesswork — to drive the tuning methodologies. This chapter shows you how to monitor and tune the shared SQL area of the shared pool, as well as what to pin, and looks at other areas such as multithreaded server, hashing, and the generalized tuning of the library and data dictionary cache areas.

Defining the Shared Pool?

Many people know that the shared pool is a part of ...

Get Oracle Internals now with O’Reilly online learning.

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