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

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.