Re: how to monitor the progress of inserts

On Wed, 2 Feb 2005 09:59:00 -0500, rjamya <rjamya@xxxxxxxxx> 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
> <juancarlosreyesp@xxxxxxxxx> 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

Other related posts: