Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Help

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US