How to Generate Tkprof and User of Tkprof

Use of Tkporf :

              Tkprof is used to convert Binary file ( Trace File ) to  Text file ( Readable format ).


How to Generate TkProf :

Below i have given trace file name( . trc ) and text file name( .txt ) ,trace file (binary format ) data will be copied to text file ( Readable format ).after i have given sorting order like executing,fetching and parsing

$ tkprof /Oracle/app/oracle/admin/dev/udump/rpm12_ora_20524.trc                                        /Oracle/app/oracle/admin/dev/udump/rpm12_ora_20524.txt   sort=exeela,fchela,prsela

Check :

After Generating tkprof i have checked in cat command or more command,below i have given just example of the text file ( i have pasted just few lines only below text ).

[oracle@slm~] $ cat /Oracle/app/oracle/admin/RMSCZ01/udump/rmscz01_ora_27878.txt

TKPROF: Release 10.2.0.4.0 - Production on Thu Mar 2 15:23:03 2017

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Trace file: /Oracle/app/oracle/admin/dev/udump/rpm12_ora_27878.trc
Sort options: exeela  fchela  prsela
********************************************************************************
count    = number of times OCI procedure was executed
cpu      = cpu time in seconds executing
elapsed  = elapsed time in seconds executing
disk     = number of physical reads of buffers from disk
query    = number of buffers gotten for consistent read
current  = number of buffers gotten in current mode (usually for update)
rows     = number of rows processed by the fetch or execute call
********************************************************************************

select (:b0||ticb_loc)
from
 tsc_po_req_tsf where (ext_ref_no=TO_NUMBER(:b0) and rownum=1)


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute    272      0.03       0.03          0          0          0           0
Fetch      272    379.58     383.56      65462    8950848          0         272
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      545    379.62     383.60      65462    8950848          0         272

Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: 63

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                     271        0.00          0.00
  db file sequential read                        35        0.01          0.02
  db file scattered read                       4325        0.09          9.48
  latch free                                      2        0.00          0.00
  SQL*Net message from client                   271        0.00          0.10
  latch: cache buffers chains                     4        0.00          0.00
********************************************************************************