Main / Trivia / Tkprof utility

Tkprof utility

Tkprof utility

Name: Tkprof utility

File size: 808mb

Language: English

Rating: 6/10



If you have a problem query you can user TKPROF to get more information. To get the most out of the utility you must enable timed statistics by setting the . This is from the book Oracle Utilities: Using Hidden Programs, Import/Export, SQL Loader, oradebug, Dbverify, Tkprof and More Order now and. You can run the TKPROF program to format the contents of the trace file and place the output into a readable output file. Optionally, TKPROF can also.

TKProf is an Oracle database utility used to format SQL Trace output into human readable format. The TKProf executable is located in the. So instead of giving you all possible options of turning on SQL Trace and all possible flags TKPROF utility accepts I'll show you exactly how. The TKPROF utility is also known as the SQL trace facility. In addition to the execution plan, TKPROF provides a detailed report that shows the execution details.

If you just type "tkprof" at the OS command prompt it lists its parameters and their meaning like this: > tkprof Usage: tkprof tracefile outputfile [explain= ] [table= ]. 2 Jul - 3 min Excerpt from TKProf Utility Training Video. Developer uses Tkprof utility frequently for oracle. 26 Aug - 15 min - Uploaded by Stephen Frein Demonstration of generating Oracle trace files and then turning these into tuning reports with.