RE: Tracing a user session with multiple database connections
Title: RE: Tracing a user session with multiple database connections 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- From: Schauss, Peter [mailto:[EMAIL PROTECTED]] Sent: Monday, August 18, 2003 11:29 PM To: Multiple recipients of list ORACLE-L Subject: Tracing a user session with multiple database connections 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).
Re: Tracing a user session with multiple database connections
Schauss, Peter wrote: Is there any way to trace all of the connections for a given sid without setting sql_trace for the entire instance? You could try creating a trigger to do it. "create trigger foo after login on database ..." -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Lamb 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).
Tracing a user session with multiple database connections
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).