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).
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..