My Oracle Support Banner

Guidelines for Interpreting TKPROF Output and Avoiding Traps in TKPROF Interpretation (Doc ID 2556202.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 9.0.1.0 and later
Information in this document applies to any platform.



Purpose

This document provides guidelines for interpreting TKPROF outputs and it helps to be aware of common traps.

Scope

For users needing advice on how to use TKPROF outputs to tune problem queries and resolve application performance problems.

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
  Guideline for Interpreting the Resolution of Statistics 
 Guideline for Recursive SQL Statements
 Guideline for Deciding Which Statements to Tune
 Guidelines for Avoiding Traps in TKPROF Interpretation
 Guideline for Avoiding the Argument Trap
 Guideline for Avoiding the Read Consistency Trap
 Guideline for Avoiding the Schema Trap
 Guideline for Avoiding the Time Trap
References

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