Path: news.easynews.com!easynews!ps01-sjc1!news.webusenet.com!cyclone.bc.net!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: sam777t@yahoo.com (Sam Talebbeik)
Newsgroups: comp.databases.oracle.server
Subject: Producing SQL statments from trace files fails.
Date: 8 Aug 2002 17:35:49 -0700
Organization: http://groups.google.com/
Lines: 34
Message-ID: <9ec3a1ef.0208081635.e00ee20@posting.google.com>
NNTP-Posting-Host: 208.171.192.196
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1028853349 1367 127.0.0.1 (9 Aug 2002 00:35:49 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 9 Aug 2002 00:35:49 GMT
Xref: easynews comp.databases.oracle.server:157317
X-Received-Date: Thu, 08 Aug 2002 17:32:54 MST (news.easynews.com)

I am running Oracle 8.1.7 on NT . I have set the SQL_TRACE= TRUE in the
init.ora file. The trace files get created in the udump directory.

However when I look at the trace files or the output created by the tkprof
I do not see any of the SQL statements that is generated by the application.
I even went into sqlplus and issued "alter session set sql_trace=true" ,
issued a sql statement, and exited from sqlplus.
I still do not see the text of the sql statement. All sql statements seem
to be internal server statements 

The output of the tkprof claims that 
the number of user level SQL statements is 0. 

Here is the last part of the tkprof output :

    0  user  SQL statements in session.
 1150  internal SQL statements in session.
 1150  SQL statements in session.
********************************************************************************
Trace file: ora817snp0.trc
Trace file compatibility: 8.00.04
Sort options: default

     460  sessions in tracefile.
       0  user  SQL statements in trace file.
  264500  internal SQL statements in trace file.
    1150  SQL statements in trace file.
       5  unique SQL statements in trace file.
    8067  lines in trace file.

Anyone knows why ?

    Thanks,
    Sam