Oracle Database 11g: Shared Pool and Buffer Cache Tuning


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
The buffer cache is an extremely important component for the performance, scalability, and reliability of the database. This course demonstrates how to identify the symptoms that indicate a buffer cache problem and how to use the various methods available to resolve common performance issues related to the buffer cache. It also discusses the sizing of the buffer cache and using views to analyze the buffer cache, and briefly covers multiple pool management. The fundamental purpose of the shared pool is to serve as a metadata cache. This course explains how to diagnose and resolve hard and soft-parsing problems and shared pool fragmentation issues. It also discusses various methods of tuning the shared pool, including sizing the shared pool, sizing the reserved area of the shared pool, keeping objects in the shared pool, and managing the results cache.

Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.

Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II

Expected Duration (hours)
2.0

Lesson Objectives

Oracle Database 11g: Shared Pool and Buffer Cache Tuning

  • recognize the features of the shared pool
  • identify the role of AWR and Statspack reports indicators when diagnosing problems
  • recognize how to avoid hard parses
  • recognize how to avoid soft parses
  • recognize how to reserve space in the shared pool
  • recognize how to manage the results cache
  • recognize the features of the buffer cache architecture
  • identify the symptoms that indicate a buffer cache problem
  • identify methods to resolve common performance issues related to the buffer cache
  • recognize how to properly size the buffer cache
  • manage the buffer cache in given scenarios
  • Course Number:
    od_odpt_a06_it_enus