Tuning the Shared Pool

Objectives

The Shared Global Area

The Shared Pool

The Library Cache

The Library Cache

Tuning the Library Cache

Tuning the Library Cache

Terminology

Diagnostic Tools
for Tuning the Library Cache

Are Cursors Being Shared?

Guidelines: Library Cache Reloads

Guidelines: Library Cache Reloads

Invalidations

Sizing the Library Cache

Global Space Allocation

Large Memory Requirements

Tuning the Shared Pool
Reserved Space

Keeping Large Objects

Anonymous PL/SQL Blocks

Other Parameters Affecting the
Library Cache

The Data Dictionary Cache, Terminology, and Tuning

Diagnostic Tools for Tuning the Data Dictionary Cache

Tuning Data Dictionary Cache

Guidelines: Dictionary Cache Misses

UGA and MTS

Sizing the User Global Area

Large Pool

Summary