From oracle-l-bounce@freelists.org Wed Feb 2 10:23:32 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j12GNVQl020528 for ; Wed, 2 Feb 2005 10:23:31 -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 j12GNUem020522 for ; Wed, 2 Feb 2005 10:23:30 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 431106C2E3; Wed, 2 Feb 2005 10:22:35 -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 31406-05; Wed, 2 Feb 2005 10:22:35 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BAF926C2D9; Wed, 2 Feb 2005 10:22:34 -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=fR6uT4SNBkkrTEBk2D3BX98+TeMiCbCqgmrD8Na8EcIJK0Jpc8dU2U2wkBRC7joYkEioXehVR/UA67pGV+zx3Fk0ET/Cdf6PFL/2pNsPtrEGyRmBgetfKmBsXcY6YdOweSwDCtoS+FsYeKSe0F1/mdOUc1powIDuoxclB8XPJ+U= Message-ID: Date: Wed, 2 Feb 2005 11:20:28 -0400 From: Juan Carlos Reyes Pacheco To: rjamya Subject: Re: how to monitor the progress of inserts Cc: Oracle Discussion List In-Reply-To: <9177895d050202065916266bf4@mail.gmail.com> 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> <9177895d050202065916266bf4@mail.gmail.com> X-archive-position: 15677 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: juancarlosreyesp@gmail.com Precedence: normal Reply-To: juancarlosreyesp@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=AWL autolearn=ham version=2.60 X-Spam-Level: On Wed, 2 Feb 2005 09:59:00 -0500, rjamya wrote: > 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. That is a better idea, > But we are talking about the question > from the original poster. Rjamya, I didn't find a way to know how much inserts are in the moment, the previous was the best idea to an "exact" measure. But what about to measure blocks instead of records , and use v$sesstat, or you think still is posible to know the exact amount of insert at a specific moment in a session (from another session). > > 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; > > / > > > -- Oracle 9i,10g Certified Professional (Experience on Orace 7,8i) Developer 6i Certified Professional 8 years of experience in Administration, developing and design -- http://www.freelists.org/webpage/oracle-l