What is Tkprof file?

2020-09-25 by No Comments

What is Tkprof file?

The TKPROF program converts Oracle trace files into a more readable form. 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 init. ora parameter or performing the following command.

How do you read a Tkprof output?

Each tkprof output file contains a header, body, and summary section. The header simply displays the trace file name, definitions, and sort options selected. The body contains the performance metrics for SQL statements.

How do I Analyse a Tkprof trace file in Oracle?


  1. Identify SQL statements that do not use bind variables.
  2. Identify statements that perform full table scans.
  3. Identify statements that are doing multiple disk reads or have high CPU consumption.
  4. Compare the number of parses and executions.

What is Tkprof in Oracle with example?

TKPROF can generate a SQL script that creates a table and inserts rows of statistics into it. This script contains: A CREATE TABLE statement that creates an output table named TKPROF_TABLE . INSERT statements that add rows of statistics, one for each traced SQL statement, to the TKPROF_TABLE .

How do I convert TRC to Tkprof?

Tkprof – Convert Trace . trc to Readable

  1. tkprof: is command.
  2. : is file name of trace file with location (if currently not in same directory)
  3. : is output file name.
  4. explain= /: provide apps user name and password.

What is TRC file in Oracle?

Trace File are trace (or dump) file that Oracle Database creates to help you diagnose and resolve operating problems. When a process detects an internal error, it writes information about the error to its trace file.

What is the difference between Tkprof and explain plan?

This example shows TKPROF being run to format a trace file named “dsdb2_ora_18468. trc” and writing it to a formatted output file named “dsdb2_trace. out”. The EXPLAIN PLAN command displays the execution plan chosen by the Oracle optimizer for SELECT, UPDATE, INSERT, and DELETE statements.

How do I read a trace file?

Open a trace log using Traceview

  1. Start Android Device Monitor.
  2. In the Android Device Monitor, select File > Open File.
  3. Navigate to the . trace file you want to inspect.
  4. Click Open.

How do I use a TRC file?

File created by SQL Server Profiler, which is included with SQL Server software; contains trace results of the activity of a SQL database; can be used to analyze a sequence of database statements. To open a TRC file, select File → Open → Trace File, select your Trace file, and click Open.

Can TRC files be deleted?

The . trc files are safe to delete. . trc files generated by SQL Server in process of saving events to a physical file without using the Profiler client tool.

How explain plan works in Oracle?

Running EXPLAIN PLAN EXPLAIN PLAN FOR SELECT last_name FROM employees; This explains the plan into the PLAN_TABLE table. You can then select the execution plan from PLAN_TABLE . This is useful if you do not have any other plans in PLAN_TABLE , or if you only want to look at the last statement.

How to use trcsess and tkprof in Oracle?

SQL trace, 10046, trcsess and tkprof in Oracle The quickest way to capture the SQL being processed by a session is to switch on SQL trace or set the 10046 event for a representative period of time. The resulting trace files can be read in their raw state or translated using the tkprof utility.

How to do a tkprof analysis in orcl92?

C:\\oracle9i\\admin\\ORCL92\dump> tkprof ORCL92_ora_3064.trc output.txt insert= tkprof .sql record=Allsql.sql Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Based on the command above, tkprof will process the file ORCL92_ora_3064.trc and format the results in the file output.txt.

What is the tkprof output from previous post?

Following is the TKProf Output from previous post ( Oracle TKProf Usage) that we are going to interpret:- Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. Event waited on Times Max. Wait Total Waited 1. Tabular Statistics

What can a tkprof trace file be used for?

It essentially formats a trace file into a more readable format for performance analysis. The DBA can then identify and resolve performance issues such as poor SQL, indexing, and wait events. tkprof has been historically difficult to use for many reasons.