Re: Performance &Tunning

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 19 Mar 2004 17:21:05 +1100
Message-ID: <405a9155$0$3953$afc38c87@news.optusnet.com.au>

"Sharbat" <sharbats_at_hotmail.com> wrote in message news:68aa131b.0403182140.7923d03_at_posting.google.com...
> Hey,
>
> Could some one give me the idea that how to enable SQL trace
> implicitly for a particular program (EXCEL), whenever it connect to
> database.
> So only enable the SQL TRACING for that session which is running that
> program.
>
>
> Sharbat

Connect via Excel, then select from v$session on the server. Find the sid and serial# of the Excel session.

With that information to hand,

exec dbms_system.set_sql_trace_in_session(sid,serial#,true)

And then to close off the trace file properly:

exec dbms_system.set_sql_trace_in_session(sid,serial#,false)

Regards
HJR Received on Fri Mar 19 2004 - 00:21:05 CST