Written by Ira Singer, Oracle DBA
Understanding
the Shared Pool for Tuning, a recent webinar, I talked
about
parsing the library cache of the shared pool, how to cut down on
hard parses,
and AWR (Automatic Workload Repository) findings to help tune the
library cache.
The main purpose of the shared pool is to share your
SQL
statements -- your execution plans, especially for online
transaction
processing. There are other areas in the shared pool that can be
used, butthere are...