Course Details

Previous Page


Oracle Database 11g: Application Tracing and Automatic SQL Tuning


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



Overview/Description
Oracle Database implements tracing by generating a trace file for each server process when you enable the tracing mechanism. This course explores configuring the SQL Trace facility to collect session statistics, using the TRCSESS utility to consolidate SQL trace files, formatting trace files using the tkprof utility, and interpreting the output of the tkprof command. Tuning statements automatically eases the entire SQL tuning process and replaces manual SQL tuning. Statement profiling, and using the SQL Tuning Advisor, the SQL Access Advisor, and Automatic SQL Tuning are also covered in this course.

Target Audience
Support engineers, developers, technical consultants, data warehouse developers, and application developers.

Prerequisites
Oracle Database 11g: Introduction to SQL Oracle Database 11g: SQL Fundamentals I

Expected Duration (hours)
2.5

Lesson Objectives

Oracle Database 11g: Application Tracing and Automatic SQL Tuning

  • recognize how to configure the SQL trace facility
  • recognize how to use the trcsess utility
  • recognize how to use the tkprof utility
  • perform application tracing
  • recognize how statement profiling works
  • recognize how to use the SQL Tuning Advisor
  • recognize the features of the SQL Access Advisor
  • recognize the features of Automatic SQL Tuning
  • perform SQL tuning and use the SQL Access Advisor
  • Course Number:
    od_ortw_a05_dt_enus