Oracle Database 10g: New Tuning, Performance-monitoring, and Analysis Features


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


Overview/Description
To use Oracle 10g's new tuning, performance-monitoring, and analysis features

Target Audience
Oracle 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration (hours)
3.0

Lesson Objectives

Oracle Database 10g: New Tuning, Performance-monitoring, and Analysis Features

  • identify how to use the new optimizer statistics in Oracle Database 10g.
  • use the SQL Tuning Advisor in a given scenario.
  • use the SQL Access Advisor in a given scenario.
  • recognize how Oracle 10g database performance is monitored.
  • use the SQL Tuning Advisor and the SQL Access Advisor in a given scenario.
  • use MERGE and partitioned outer joins in a given scenario.
  • use group mapping in interrow calculations in a given scenario.
  • recognize materialized view operations in a given scenario.
  • use analytical calculations and fast refresh capabilities in a given scenario.

    • Course Number:
    220637_eng