From oracle-l-bounce@freelists.org Wed Feb 2 14:11:05 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j12KB5Zw017380 for ; Wed, 2 Feb 2005 14:11:05 -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 j12KB1em017367 for ; Wed, 2 Feb 2005 14:11:02 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 307CF6CC65; Wed, 2 Feb 2005 14:10:04 -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 17562-08; Wed, 2 Feb 2005 14:10:04 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A288C6CDA5; Wed, 2 Feb 2005 14:10:03 -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=t5L/bcCrC+m+FQLlaNmrcuQvXmYHR3kFppMqFeHKZeUk7LQoRMmAy2t2iaiHEPRmEDDAubQGY8Otl4nr5UlvcqaKtERylMy+ySFFWPkRuxVYxfmZB3q9VSBDHF9TWu8vso4UVrLBSUc9O1+czVchdbExO5iwEKZIYyzGMKLmbFo= Message-ID: Date: Wed, 2 Feb 2005 15:08:23 -0400 From: Juan Carlos Reyes Pacheco To: rjamya 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> <9177895d050202065916266bf4@mail.gmail.com> X-archive-position: 15694 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: What about using SELECT * FROM SYS.V_$SEGMENT_STATISTICS You gather before the insert, then after and based on the row size you can get an average of the amount of inserts done. On Wed, 2 Feb 2005 11:20:28 -0400, Juan Carlos Reyes Pacheco wrote: > 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 > -- 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