Turning SQL tracing on for a Java application
Date: 28 May 2003 12:46:53 -0700
Message-ID: <240a4d09.0305281146.31db17d6_at_posting.google.com>
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!