Re: how to monitor the progress of inserts

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 <juancarlosreyesp_at_gmail.com> wrote:
> On Wed, 2 Feb 2005 09:59:00 -0500, rjamya <rjamya_at_gmail.com> 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_at_gmail.com> 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