Oracle Database Discussions

Hi,

My question is simple. I'm required to push some data from one environment to another, because the volume of data is significant I'd like to have an estimate of the progress.

I'm just doing an direct-path insert by using a simple query like:

INSERT /*+ APPEND */  INTO TABLE

SELECT * FROM TABLE@DBL_DWQ;

Since it does not go to v$session_longops, can I get something out of v$transaction? I can see info like used_ublk and used_urec, but I'm not sure if I can infer something out of these fields. Let's say that the table has 40M of records, before ending the value of used_urec will be of 40M? If the current value of used_urec is 20M can I say that half the transaction is done? Or there is not a simple one-to-one relation between used_urec and total number of rows to insert?

Thanks in advance.