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 8i or 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
180 Minutes
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