Oracle-L: RE: Tracing a user session with multiple database connections

From: Aponte, Tony <AponteT_at_hsn.net>
Date: Tue, 19 Aug 2003 09:09:32 -0800
Message-ID: <F001.005CB8CB.20030819090932@fatcity.com>

It may need some changes for the Alter Session syntax but the trigger should help you isolate the activity by these session.

HTH
Tony Aponte

CREATE OR REPLACE TRIGGER sys.trap_conversion_connect_trig   AFTER LOGON ON conversion.SCHEMA
BEGIN
  BEGIN
    EXECUTE IMMEDIATE 'ALTER SESSION SET EVENTS ''10046 TRACE NAME CONTEXT FOREVER,LEVEL 12''';   EXCEPTION
  WHEN OTHERS THEN
       SYS.DBMS_SYSTEM.KSDWRT(2,SQLERRM);   END;
END; -----Original Message-----
Sent: Monday, August 18, 2003 11:29 PM
To: Multiple recipients of list ORACLE-L

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

--

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

Author: Aponte, Tony
INET: AponteT_at_hsn.net

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