Re: trace sql statements

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Sat, 24 May 2003 11:07:34 +0200
Message-ID: <2fducv4drhp68eei7hcr53i682dprir98u@4ax.com>

On 24 May 2003 08:19:37 GMT, Urs Stotz <stotz_at_gmx.ch> wrote:

>Hello
>
>Is it possible each sql statement to trace of an other oracle session?
>I need to know the statements of an application during a
>benchmark/portfolio calculation.
>
>kind regards
>Urs

refer to dbms_system.set_sql_trace_in_session(sid, serial#)

Must be sys to run this

or find the os processid
and in sqlplus connected as sys issue
oradebug setospid <pid you found>
oradebug event 10046 trace name context forever, level 1

or use the dbms_system.set_ev procedure.

Numerous options!

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat May 24 2003 - 04:07:34 CDT