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.

Ups.. It seems there are no reviews for this training yet! Go on and be the first to write a review!