Oracle Database 11g: Performance Enhancements

Overview/Description
identify the scope and capabilities of Oracle Database 11g's performance-enhancing tools, such as those for memory management, performance analysis, and statistics gathering.

Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA's considering upgrading their systems to 11g

Prerequisites
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration (hours)
1.6

Lesson Objectives

Oracle Database 11g: Performance Enhancements

recognize the different ways to use Automatic Database Diagnostic Monitor to analyze Oracle Real Application Clusters (RACs) and report on issues affecting the entire database as well as individual instances.

identify the benefits of Oracle Database 11g's Automatic Memory Management system.

identify the concepts and methods employed in Oracle database 11g for gathering and publishing various kinds of statistics.

identify the steps for observing memory distribution patterns using Automatic Memory Management and also for testing various statistic gatherings on a particular table.

use Automatic Memory Management to observe memory distribution patterns.