Optimizing Database Performance in Oracle 10g

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

Overview

To outline the processes and considerations for optimizing an Oracle database using alerts, trace files, and advisors

Target Audience

Oracle database administrators and database operators

Prerequisites

Experience in Oracle database administration; mastery of Associate level content for Oracle 10g; proficiency in programming with SQL and PL/SQL

Expected Duration

140 min.

Course Objectives

Optimizing Database Performance in Oracle 10g

  • view and configure alerts.
  • identify situations when trace files and SQL tracing are useful.
  • use Oracle Database 10g diagnostic tools to resolve database problems in a given scenario.
  • recognize situations to run ADDM.
  • recognize when to use the SQL Tuning Advisor and Access Advisor.
  • use the Segment Advisor and Undo Advisor to implement appropriate space management settings.
  • use appropriate Oracle advisor tools in given scenarios.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?