From oracle-l-bounce@freelists.org Mon Jun 13 21:40:13 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j5E2eDCI007695 for ; Mon, 13 Jun 2005 21:40:13 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j5E2eDNi007691 for ; Mon, 13 Jun 2005 21:40:13 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 560221BD638; Mon, 13 Jun 2005 20:36:56 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02311-02; Mon, 13 Jun 2005 20:36:56 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D403E1BD54C; Mon, 13 Jun 2005 20:36:55 -0500 (EST) Date: Tue, 14 Jun 2005 01:35:06 +0000 From: Mladen Gogala Subject: Re: How to trace a session in MTS (8iR3) To: oracle-l References: <56DB353DC7975A4FAD846277407329090146CE83@bsbrsp42.bs.br.bsch> In-Reply-To: <56DB353DC7975A4FAD846277407329090146CE83@bsbrsp42.bs.br.bsch> (from lcerri@santanderbanespa.com.br on Mon Jun 13 20:14:49 2005) Message-Id: <1118712906l.5038l.0l@medo.noip.com> MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: 8bit X-archive-position: 21059 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: gogala@sbcglobal.net Precedence: normal Reply-To: gogala@sbcglobal.net X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.5 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 On 06/13/2005 08:14:49 PM, Luis Fernando Cerri wrote: > Hello, fellows! This greeting is, I presume, meant for the ladies as well? > Taking a session-to-processes look, I noticed that the same session (SID) > has different SPID in v$processes during its lifecycle. So, when people c= all > me saying that a reporting is longing more than 10 times the usual time, = how > do I trace that specific session in MTS? You should use dbms_monitor.session_trace_enable to turn on tracing in the desired session and then combine traces with trcsess session=3D ou= tput=3Djigsaw.trc. Once you combine the traces, you can use tkprof on the resulting file. If y= our database version is < 10, you have a problem. --=20 Mladen Gogala Oracle DBA -- http://www.freelists.org/webpage/oracle-l