Re: Performance &Tunning

Thanks for reply.

I like to ask you, should we enable SQL TRACING inside the EXCEL Program or IS there another approach that SQL Tracing Enable automatically for that session whenever it runs EXCEL.

Your ideas will be appreciated.

Sharbat

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<405a9155$0$3953$afc38c87_at_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 - 07:44:09 CST