Re: how to monitor the progress of inserts
- From: Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx>
- To: rjamya <rjamya@xxxxxxxxx>
- Date: Wed, 2 Feb 2005 09:30:29 -0400
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;
/
Then you could see the inserts he had done doing a query to
test.inserts, before he commits.
Is that what you want?
On Wed, 2 Feb 2005 07:27:35 -0500, rjamya <rjamya@xxxxxxxxx> wrote:
> ... EXCEPT that when you use dbms_output, it is visible to you ONLY
> AFTER the whole process is finished. Which doesn't help the OP at all.
>
> Raj
>
>
> On Tue, 1 Feb 2005 19:03:31 -0400, Juan Carlos Reyes Pacheco
> <juancarlosreyesp@xxxxxxxxx> wrote:
> > I think this solves the problem if the code can be modified, without
> > harming performance.
> >
> > SQL> CREATE or replace PACKAGE TEST
> > 2 IS
> > 3 nCount NUMBER :=0;
> > 4 END;
> > 5 /
> >
> > SQL> create table test2 as select * from dba_objects where 1=0;
> > SQL> select count(*) from dba_objects;
> >
> > COUNT(*)
> > ---------
> > 29541
> >
> > SQL> begin
> > 2 INSERT INTO test2 select * from dba_objects ;
> > 3 test.ncount := test.ncount + sql%rowcount;
> > 4 dbms_output.put_line('total inserted:'||test.nCount);
> > 5 rollback;
> > 6 end;
> > 7 /
> > total inserted:29541
> > --
> > //www.freelists.org/webpage/oracle-l
> >
>
> --
> ------------------------------
> select standard_disclaimer from company_requirements where category =
> 'MANDATORY';
>
--
Oracle 9i,10g Certified Professional (Experience on Orace 7,8i)
Developer 6i Certified Professional
8 years of experience in Administration, developing and design
--
//www.freelists.org/webpage/oracle-l
Other related posts:
