Re: Oracle Help

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 5 Sep 2001 18:24:48 +0200
Message-ID: <tpckf0b5pe85e3@news.demon.nl>

"Sivakumar S" <psshiva_at_india.hp.com> wrote in message news:3B95E6F1.93E0F04D_at_india.hp.com...
> Hello All,
>
> Is there a way to trace the sql statements executed in a particual
> (database)connection?
>
> with regds
> siva

Yes there is.

connect as sys
issue
exec dbms_system.set_sql_trace_in_session(<sid>,<serial#>, true)

You can find sid and serial in the v$session dictionary view.

Hth

Sybrand Bakker, Senior Oracle DBA Received on Wed Sep 05 2001 - 11:24:48 CDT