From oracle-l-bounce@freelists.org Wed Mar 3 04:11:35 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i23ABY713633 for ; Wed, 3 Mar 2004 04:11:34 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i23ABWo13624 for ; Wed, 3 Mar 2004 04:11:32 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B63D3394EEC; Wed, 3 Mar 2004 05:11:58 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 03 Mar 2004 05:10:50 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mail2.summitworks.com (unknown [65.202.208.195]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3E4F3394EA1 for ; Wed, 3 Mar 2004 05:10:47 -0500 (EST) Received: from senkumar [61.11.73.102] by mail2.summitworks.com with ESMTP (SMTPD32-8.05) id AF601910168; Wed, 03 Mar 2004 05:11:44 -0500 From: "Senthil Kumar" To: Subject: RE: How to trace what particular session is doing? Date: Wed, 3 Mar 2004 15:55:04 +0530 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 In-Reply-To: Importance: Normal X-archive-position: 137 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: senthilkumard@summitworks.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l Hi, take the sid,serial# of the session. then use exec sys.dbms_system.set_sql_trace_in_session(sid,serial#,true); then analyze your user trace file. Senthil. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Jay Sent: Wednesday, March 03, 2004 8:11 AM To: oracle-l@freelists.org Subject: How to trace what particular session is doing? Dear All, I like to trace what particular session is doing at given point in time? I know something i have to join v$session,v$process,v$transaction and v$sql but somehow not able to get succeed. Does anyone have a script for the same? Thanks Jay ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------