-
Output of trace file
Hi all
I am attching a trace file
plese help me what is indicating.
I have run TKPROF but unable to get any thing
copy of TKPROF output
TKPROF: Release 8.1.7.0.0 - Production on Thu Jun 19 09:20:57 2003
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Trace file: ORA02428.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: ORA02428.trc
Trace file compatibility: 8.00.04
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.
1605 lines in trace file.
Thanks in adv.
P.Soni
-
What type of trace file you are looking into? Is it the file generated by turning trace ON. Or is it an error trace file ? Can you post the trace file itself (as attachment) if it is not too big?
-
I don't think your timed_statistics are on...
Anyways check this thread for tkprof related usage...
http://www.dbasupport.com/forums/sho...ghlight=TKPROF
-
Having done that put that trace formatted file in the attachement. Then we'll see...;)
-
1 Attachment(s)