From oracle-l-bounce@freelists.org Wed Feb 2 10:01:48 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j12G1lIJ015699 for ; Wed, 2 Feb 2005 10:01:47 -0600 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 j12G1jem015686 for ; Wed, 2 Feb 2005 10:01:45 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E75CE6C71D; Wed, 2 Feb 2005 10:00:43 -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 26591-05; Wed, 2 Feb 2005 10:00:43 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 767766C70C; Wed, 2 Feb 2005 10:00:43 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=LXu20n5nFVdG0qZUlAEPt9LEEZ87xskbVMgl019wtN5TlwS7wIHydweUvcRxquhxfb3RbH2bEymFN7RA/3PXHrAkS7GWPUhMsC7+9PBrqP2eYhXBshlYMRCxP6oSlvodzBnbSng8tQ23hrw0jXEy18Bw6TtisYRTKIG7oEz8oXs= Message-ID: <9177895d050202065916266bf4@mail.gmail.com> Date: Wed, 2 Feb 2005 09:59:00 -0500 From: rjamya To: Juan Carlos Reyes Pacheco Subject: Re: how to monitor the progress of inserts Cc: Oracle Discussion List In-Reply-To: Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: <41FFFA47.50407@centrexcc.com> <1107298218l.9692l.0l@medo.noip.com> <9177895d050202042720bfadb8@mail.gmail.com> X-archive-position: 15676 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rjamya@gmail.com Precedence: normal Reply-To: rjamya@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.60 X-Spam-Level: Juan, Don't you think it would be easier to use dbms_application_info and set the number of records in ACTION column? no worries with autonomous transaction, dbms_output etc. Plus you have a chance to have your application well behaved and instrumented. Someone might even thank you for it later. 8:) Then it it remains is select from v$session ... sounds good?? As for I am concerned, my processes are pretty much verbose, they tell me exactly what I want to know. But we are talking about the question from the original poster. Raj On Wed, 2 Feb 2005 09:30:29 -0400, Juan Carlos Reyes Pacheco wrote: > Hi, > The point rjamya is you don't specified what you want exactly, but > what I understand > is someone is doing a SPECIFIC process, and you want to know how much > inserts that SPECIFIC PROCESS had done before he commit, FROM ANOTHER > SESSION. > > In that case you can call an autonomous transaction instead of the > dbms_outoup in that session, this is > > CREATE OR REPLACE PROCEDURE SAVE_CONTROL_OF_INSERTS > ( nNumber ) > IS > PRAGMA AUTONOMOUS_TRANSACTION; > BEGIN > UPDATE TABLE TEST SET INSERTS=INSERTS+nNumber ; > COMMIT; > END; > / > -- http://www.freelists.org/webpage/oracle-l