Originally posted by jmodic
?????
Originally posted by tamilselvan
The rows_processed column value in v$sqlarea is posted after insert operation completes its entire work.
This may not help to figure out how many rows are inserted so far when the sql is running.

Tamil
Well, all i can say is I posted the reply in haste not even thinking what was really asked..

Originally posted by slimdave
You might get something useful from V_$SESSION_LONGOPS
I think i am late coming into this party :-)
Well to all who have aggreed that this is the method..

Not all Operations running long are captured in V$Session_Longops..
So for Index scan/Nested Joins any many other will not be populated in Session Longops, in which case again we are in fix...

V$Transaction -> Used_Urec will/may help in this regard to find number of rows inserted..Well it is one to one match if its a Single Row Insert..which presently is not..Present scenerio is Array Insert or rather Bulk Insert Type..for such Inserts one record is incremented in the Used_Urec Col for Every Block getting affected during insert...

So, knowing the number of blocks that will be returned by Select Query and substracting the value/2 in the Used_Urec will give an approx picture of how many more blocks needs to be inserted...

Hope i am correct this time...(Jurij/Slimdave/Tamil please yell at me if i am wrong :-)

Abhay.