Performance And Tunning

[Chuck]

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.
I needed to enable the SQL TRACING only for that session which is running that program (Excel).

Your ideas will be appreciated.

Sh*****

[nagarjuna]

You can write system level triggers for that program and then get the sid and use it to enable the trace. dbms_system is the package to enale trace for another session. Youn can get further into this..

[slimdave]

"Performance And Tunning"?

[pando]

cant even write a proper thead title? geeeez

[ganga]

HI slindev.

coudl you plz give me link for goddam

[davey23uk]

surely you are joking

[stmontgo]

Can't this be done through the odbc level?

[Chuck]

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.

CHUCK

[millerg]

We should have a poll to vote for the most obnoxious correspondant, pando or slim "no OCP, no Oracle Masters, no nothing, just so far up myself you can't see me" dave.

[slimdave]

Originally posted by millerg
We should have a poll to vote for the most obnoxious correspondant, pando or slim "no OCP, no Oracle Masters, no nothing, just so far up myself you can't see me" dave.

In that case, my vote goes to Pando.

And it's "correspondent" -- my mission is to educate!