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

This course is included in our On-demand training solution.

Overview

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

180 min.

Course 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.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?