Re: how to monitor the progress of inserts

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Tue, 1 Feb 2005 19:03:31 -0400
Message-ID: <cd4305c1050201150354e0d1fc@mail.gmail.com>

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 Received on Tue Feb 01 2005 - 18:06:07 CST