Note that dbms_system is owned by SYS, and by default no-one else is
given access to it. So if you want to execute it as a non-SYS user
you'll first need to grant EXECUTE on DBMS_SYSTEM to that user.

Kathy

-----Original Message-----
From: Patterson Joel
[mailto:oracledba-ezmlmshield-x57028071.[Email address protected]
Sent: Thursday, June 30, 2005 3:11 PM
To: LazyDBA Discussion
Subject: RE: Trace session SQL

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




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