Optimizing Database Performance in Oracle 10g
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
140 Minutes
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