Oracle Database 11g: Diagnosing the Database and Managing Memory

This course is included in our On-demand training solution.


To identify the steps for diagnosing and repairing database problems with the help of Oracle Support using Automatic Diagnostic Repository, Support Workbench, and health checks, and also for enabling and configuring automatic memory management and automatic shared memory management.

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.


Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I

Expected Duration

130 min.

Course Objectives

Oracle Database 11g: Diagnosing the Database and Managing Memory

  • identify the steps for viewing diagnostic data and incidents associated with a database problem via Automatic Diagnostic Repository and Support Workbench.
  • identify the steps for creating a service request (SR) for an incident and packaging and uploading the associated diagnostic data to Oracle Support, and also for monitoring your database’s health.
  • recognize the steps for handling block corruption and for detecting, analyzing, and repairing failures with the help of Data Recovery Advisor.
  • identify the functions of different memory structures in Oracle Database 11g.
  • recognize the steps for enabling and monitoring automatic memory management (AMM) and for enabling, configuring, and disabling automatic shared memory management (ASMM).
  • identify the steps for controlling automatic memory management in the PGA and for sizing the SGA and PGA, and recognize the guidelines for efficient memory usage.
  • enable automatic memory management and view automatic memory settings in a given scenario.