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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
