Course Details

Previous Page

Oracle Database 11g Release 2: Intelligent Infrastructure Enhancements

Target Audience
Expected Duration
Lesson Objectives
Course Number

Oracle Database 11g Release 2 offers new intelligent infrastructure features to aid DBAs by automatically gathering performance metrics for problem detection and self-tuning purposes. The information gathered can be viewed by the DBA using either reports or views, as well as the alert log. Oracle Database 11g has expanded features for automatic SQL tuning and the Automatic Workload Repository, which allows the DBA to ensure the database is running efficiently, and by using the Enhanced Resource Manager the DBA has the ability to optimize resource allocation among many different database sessions to prevent excessive overhead. This course identifies how to automatically tune SQL statements using Automatic SQL Tuning, use Automatic Workload Repository baselines to gather performance metrics, control maintenance tasks, determine I/O metrics using I/O Calibration tool, and use Resource Manager. This course is one of a series in the SkillSoft learning path that covers objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.

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; DBAs considering upgrading their systems to 11g

Expected Duration (hours)

Lesson Objectives

Oracle Database 11g Release 2: Intelligent Infrastructure Enhancements

  • setup and manage Automatic SQL Tuning
  • identify the features of AWR baselines
  • control automated maintenance tasks
  • determine and gather I/O metrics
  • identify the Resource Manager database and server consolidation features
  • identify the features of instance caging
  • creating AWR baselines
  • control an AutoTask job
  • calibrate I/O resources
  • Course Number: