From oracle-l-bounce@freelists.org Fri Sep 10 17:43:54 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i8AMhso23554 for ; Fri, 10 Sep 2004 17:43:54 -0500 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 i8AMhsI23549 for ; Fri, 10 Sep 2004 17:43:54 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1E34372CC89; Fri, 10 Sep 2004 17:49:51 -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 24951-39; Fri, 10 Sep 2004 17:49:51 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 793BF72CC50; Fri, 10 Sep 2004 17:49:50 -0500 (EST) Message-ID: <433A07749711884D8032B6A0AB115262C2BD75@conmsx07.corp.acxiom.net> From: Wolfson Larry - lwolfs To: "'Jacques Kilchoer'" , Wolfson Larry - lwolfs , oracle-l@freelists.org Subject: RE: V$SESSION_LONGOPS Date: Fri, 10 Sep 2004 17:48:10 -0500 MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 9400 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: lawrence.wolfson@acxiom.com Precedence: normal Reply-To: lawrence.wolfson@acxiom.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Jacques, Thanks, I'll go check note. I thought anything 6 seconds or over was reported. Larry -----Original Message----- From: Jacques Kilchoer [mailto:Jacques.Kilchoer@quest.com] Sent: Friday, September 10, 2004 5:27 PM To: lawrence.wolfson@acxiom.com; oracle-l@freelists.org Subject: RE: V$SESSION_LONGOPS Are you sure that the operation you were monitoring would have activity that would cause it to show in v$session_longops? Metalink note 68438.1 describes the kind of things that would show up in that view in an Oracle 8.1 database. There might be an updated Metalink note somewhere that shows the behaviour in Oracle 9.2 ********************************************************************** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- To unsubscribe - mailto:oracle-l-request@freelists.org&subject=unsubscribe To search the archives - http://www.freelists.org/archives/oracle-l/