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 and later
Oracle Database - Enterprise Edition - Version and later
Oracle Database - Personal Edition - Version and later
Information in this document applies to any platform.


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)
18.3 Understanding SQL Trace and TKPROF


For all DBAs


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
 Overview Reference for SQL_TRACE, TKProf and Explain Plan
 Tracing Related Initialization Parameters
 SQL_TRACE (10046 trace)
 Enabling SQL_TRACE
 Trace Files
 Basic Syntax of TKProf
 Explain Plan
 Creating the Plan Table
 Populating the Plan Table
 Displaying the Execution Plan
 Interpretation of Explain Plan

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