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