Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h7J5U7Q21373 for ; Tue, 19 Aug 2003 00:30:07 -0500 X-ClientAddr: 66.27.56.210 Received: from ns3.fatcity.com (rrcs-west-66-27-56-210.biz.rr.com [66.27.56.210]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h7J5U7p21368 for ; Tue, 19 Aug 2003 00:30:07 -0500 Received: from ns3.fatcity.com (localhost.localdomain [127.0.0.1]) by ns3.fatcity.com (8.12.5/8.12.5) with ESMTP id h7J32BCA016115 for ; Mon, 18 Aug 2003 20:03:04 -0700 Received: (from root@localhost) by ns3.fatcity.com (8.12.5/8.12.5/Submit) id h7J2eQmL030038 for oracle-l@orafaq.net; Mon, 18 Aug 2003 19:40:26 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005CB654; Mon, 18 Aug 2003 19:28:35 -0800 Message-ID: Date: Mon, 18 Aug 2003 19:28:35 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Schauss, Peter" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Schauss, Peter" Subject: Tracing a user session with multiple database connections Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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@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@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).