Re: how to monitor the progress of inserts

... 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
> --
> http://www.freelists.org/webpage/oracle-l
> 


-- 
------------------------------
select standard_disclaimer from company_requirements where category =
'MANDATORY';
--
http://www.freelists.org/webpage/oracle-l

Other related posts: