tkprof output not what was expected on oracle enterprise

From: dba cjb <>
Date: Wed, 7 Sep 2011 08:12:45 -0700 (PDT)
Message-ID: <>

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 - 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
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

Original text of this message