how to convert .trc into a readable format or txt file
634088Feb 17 2009 — edited Feb 17 2009Hi,
I tried using tkprof but it output similar to this :
TKPROF: Release 10.2.0.1.0 - Production on Sun Dec 28 13:42:39 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Trace file: C:\ababil_cjq0_1044568.trc
Sort options: default
********************************************************************************
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
********************************************************************************
Trace file: C:\ababil_cjq0_1044568.trc
Trace file compatibility: 10.01.00
Sort options: default
1 session in tracefile.
0 user SQL statements in trace file.
0 internal SQL statements in trace file.
0 SQL statements in trace file.
0 unique SQL statements in trace file.
238 lines in trace file.
0 elapsed seconds in trace file
Is this the correct output?
Cheers,
Sach