Tracing a user session with multiple database connections

From: Schauss, Peter <peter.schauss_at_ngc.com>
Date: Mon, 18 Aug 2003 19:28:35 -0800
Message-ID: <F001.005CB654.20030818192835@fatcity.com>

We have a third party application which makes multiple connections to the database. The application keeps one connection open for the duration of the session and then opens and closes one or more connections
in succession. Some of the connections only last for a few seconds, so running the set_sql_trace_in_session stored procedure by hand is not an option. All of the connections have the same sid.

Is there any way to trace all of the connections for a given sid without setting sql_trace for the entire instance?

This is Oracle 8.1.7 on AIX 4.3.3.

thanks,
Peter Schauss
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Schauss, Peter
  INET: peter.schauss_at_ngc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Aug 18 2003 - 22:28:35 CDT