Re: Turning SQL tracing on for a Java application

Robert Brown wrote:
> What is the best way to turn on Oracle sql tracing on for a specific
> application. I know you can set instance wide sql tracing on but that
> is not very convenient because it traces every application that uses
> that instance not just the one I am interested in. I could do
>
> EXECUTE SYS.dbms_system.set_sql_trace_in_session (sid, ...
>
> for a particular session but that means I have to do it session by
> session which is not practical since the application pools connections
> and new sessions get created and closed as the pool grows/shrinks.
>
> Is there any way to turn on tracing for all sessions of one specific
> application?
>
> Can the application itself invoke ALTER SESSION on every connection it
> creates to achieve this?
>
> Thanks!

With a version of Oracle where LOGON triggers exist, the solution should be straight forward.

HTH & YMMV HAND! Received on Thu May 29 2003 - 02:26:22 CEST