"Sharbat" <sharbats_at_hotmail.com> wrote in message
news:68aa131b.0403190544.1f567082_at_posting.google.com...
> 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
look at the answers you were given to this exact question on the web based
forum you posted to
Received on Fri Mar 19 2004 - 16:28:12 CST
