Sys
Execute dbms_system.set_sql_trace_in_session(sid,serial#,true)
Then
....false)
output in udump, use tkprof to convert it

type tkprof for parameters.

-----Original Message-----
From: James Oddo
[mailto:oracledba-ezmlmshield-x15088237.[Email address protected]
Sent: Thursday, June 30, 2005 3:08 PM
To: LazyDBA Discussion
Subject: Trace session SQL

Anyone have the steps needed to turn on tracing for a current running
session to trace the SQL that is being run in that session....I have a
canned application that is running queries on my database and there is
one function(applictation lookup) I need to capture


Oracle 9.2.0.5
Windows 2000


thanks


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page