My Oracle Support Banner

SQL_TRACE (10046), TKProf and Explain Plan - Overview Reference (Doc ID 199081.1)

Last updated on OCTOBER 13, 2023

Applies to:

Oracle Database - Standard Edition - Version 7.0.16.0 and later
Oracle Database - Enterprise Edition - Version 7.0.16.0 and later
Oracle Database - Personal Edition - Version 7.1.4.0 and later
Information in this document applies to any platform.

Purpose

This document gives an overview of some of the tools that can be used to discover more about SQL execution.
The article provides information covering SQL_TRACE, TKProf, Explain Plan and Autotrace.


This information is provided to supplement information in:

Oracle® Database SQL Tuning Guide
12c Release 1 (12.1)
E15858-15
18.3 Understanding SQL Trace and TKPROF
http://docs.oracle.com/cd/E16655_01/server.121/e15858/tgsql_trace.htm#TGSQL792

Scope

For all DBAs

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Purpose
Scope
Details
   
  
 Overview Reference for SQL_TRACE, TKProf and Explain Plan
 Communities
 Tracing Related Initialization Parameters
 <Parameter:TIMED_STATISTICS>
 <Parameter:MAX_DUMP_FILE_SIZE>
 <Parameter:USER_DUMP_DEST>
 SQL_TRACE (10046 trace)
 Enabling SQL_TRACE
 Trace Files
 TKProf
 Basic Syntax of TKProf
 Explain Plan
 Creating the Plan Table
 Populating the Plan Table
 Displaying the Execution Plan
 Interpretation of Explain Plan
 Autotrace
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.