What is TKPROF? How to run TKPROF?

By | December 6, 2016 | 56 views | Category: AOL and SYSADMIN Unix / Shell Scripts Tags: ,

Trace file is not in a understandable format, but to make it easier to understand and readable Oracle has provided a utility TKPROF.

Syntaxt to run TKPROF

TKPROF <trace-file> <output-file> [options]

Note: Its mandatory to set environment before running TKPROF.

TKPROF Example

TKPROF PerfIssue.trc PerfIssue.prf
--
--Another way with options
--
TKPROF PerfIssue.trc PerfIssue.prf explain=apps/apps table=sys.plan_table

Read this article to know how to generate Trace

Reference: http://docs.oracle.com/

WOW! Did you like this post? We'll send more interesting posts like What is TKPROF? How to run TKPROF? to you!
Enter your Email Address: