How to find how many rows are inserted

[julian]

Originally posted by slimdave
You might get something useful from V_$SESSION_LONGOPS

Yes, here is how:

Assume that before you start the "INSERT INTO TABLE SELECT ..." statement you check the number of rows you are supposed to insert, say 21411 (you run first select count(*) from table).

select round(SOFAR*21411/TOTALWORK)
from V$SESSION_LONGOPS
where username = 'SCOTT' and TIME_REMAINING > 0