Now that you have a broad understanding of how
- the dictionary cache,
- the library cache, and
- the UGA session memory
affect the efficiency of the shared pool, the next topic to discuss is tuning the shared pool.
This module discusses how to tune the shared pool.
Because the library cache plays such an integral role in shared pool tuning, much of this module is devoted to exploring the numerous considerations of tuning via the library cache.
The MouseOver below will help you review the components of the shared pool.