Xref: alice comp.databases.oracle.server:65075 comp.databases.oracle.tools:31624 Path: alice!news-feed.fnsi.net!cyclone.i1.net!nntp.abs.net!newshub2.home.com!newshub1.home.com!news.home.com!news.rdc1.pa.home.com.POSTED!not-for-mail Reply-To: "Bob Fazio" From: "Bob Fazio" Newsgroups: comp.databases.oracle.server,comp.databases.oracle.tools References: <7r7bpu$kr6$1@nnrp1.deja.com> Subject: Re: SQL Trace with Oracle 8 Lines: 32 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2314.1300 X-Mimeole: Produced By Microsoft MimeOLE V5.00.2314.1300 Message-ID: Date: Thu, 09 Sep 1999 04:50:15 GMT X-Complaints-To: abuse@home.net X-Trace: news.rdc1.pa.home.com 936852615 24.8.218.197 (Wed, 08 Sep 1999 21:50:15 PDT) NNTP-Posting-Date: Wed, 08 Sep 1999 21:50:15 PDT Organization: @Home Network You will need to modify your init.ora. Warning Will Robinson, WARNING! This will generate a whole lot of data that you most likely will never use. add this statement to your init.ora. SQL_TRACE=TRUE You can add another statement that might help in tuning. timed_statistics=true -- Bob Fazio Remove no.spam from my email to reply wrote in message news:7r7bpu$kr6$1@nnrp1.deja.com... > Folks, > I'm using Oracle8 for NT. I want to log all SQL statements that come > into the server to a file (there is a similar utility with MSSQL). Is > this possible, and how would I do it? > > TIA, > John Cherniavsky > You can email me at jchernia1@yahoo.com > > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't.