Path: news.easynews.com!easynews!news.he.net!cyclone-sf.pbi.net!64.245.249.51!sfo2-feed1.news.algx.net!allegiance!pln-e!spln!dex!extra.newsguy.com!newsp.newsguy.com!news.usenetgateway.com
From: roobaron <member@dbforums.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Producing SQL statments from trace files fails.
Date: 9 Aug 2002 02:20:50 GMT
Organization: dBforums
Lines: 9
Sender: roobaron
Message-ID: <1680094.1028857685@dbforums.com>
References: <9ec3a1ef.0208081635.e00ee20@posting.google.com>
NNTP-Posting-Host: p-593.newsdawg.com
User-Agent: forums@dbforums.com
X-Original-NNTP-Posting-Host: ns.spikeball.com
X-Original-Trace: 9 Aug 2002 02:20:50 GMT, ns.spikeball.com
Xref: easynews comp.databases.oracle.server:157323
X-Received-Date: Thu, 08 Aug 2002 19:47:12 MST (news.easynews.com)


try tkprof ... sys=no to suppress statements run by SYS (internal)

You could also have a look at v$sqlarea or v$sql to see what SQL has
been run recently.

--

Posted via dBforums\nhttp://dbforums.com