Optimizing Database Performance in Oracle 10g


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


Overview/Description
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 (hours)
2.3

Lesson 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.

    • Course Number:
    221273_eng