tkprof output not what was expected on oracle 10.2.0.4 enterprise
From: dba cjb <chris.brown_at_providentinsurance.co.uk>
Date: Wed, 7 Sep 2011 08:12:45 -0700 (PDT)
Message-ID: <d1cbfd98-1bb5-408f-906f-74ceb2fd54ea_at_u26g2000yqu.googlegroups.com>
I have set tracing up
alter session set events '10053 TRACE NAME CONTEXT FOREVER, LEVEL 1';
Trace file: d:\oracle\admin\dm2\udump\cjb2.trc Trace file compatibility: 10.01.00
Sort options: default
Date: Wed, 7 Sep 2011 08:12:45 -0700 (PDT)
Message-ID: <d1cbfd98-1bb5-408f-906f-74ceb2fd54ea_at_u26g2000yqu.googlegroups.com>
I have set tracing up
alter session set events '10053 TRACE NAME CONTEXT FOREVER, LEVEL 1';
/ run a query and then tried to tkprof the output on windows 2003 using the following
>tkprof d:\oracle\admin\dm2\udump\cjb2.trc explain=system/xx
This produces an output of the following
TKPROF: Release 10.2.0.4.0 - Production on Wed Sep 7 16:02:25 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Trace file: d:\oracle\admin\dm2\udump\cjb2.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
0 statements EXPLAINed in this session.
Trace file: d:\oracle\admin\dm2\udump\cjb2.trc Trace file compatibility: 10.01.00
Sort options: default
2 sessions 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. 194260 lines in trace file. 0 elapsed seconds in trace file.
Does anyone know why i am not getting info in .trc file eg on sorts etc reflected in txt file
Any help will be much appreciated
Chris B Received on Wed Sep 07 2011 - 10:12:45 CDT