Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: status when running an long run insert query
Assuming this is one insert statement and not something running in a loop
You can check the used_urec or used_ublk in v$transaction as an estimate.
Insert 1 record into the table and check how much space this uses. Rollback your transaction as you don't want to keep this record. Now run your insert and divide this v$transaction.used_urec by the number you calculated above. This should give you a rough estimate of how many rows have been inserted.
If you are doing this in a loop you can check the rows_processed from v$sql. This will show you all the rows processed for this statement since the last commit. If this statement is reused often you may want to get this number before you start running your insert statement.
HTH
Scott.
"frank12345" <fluo_at_stirlingdouglas.com> wrote in message
news:5025b594.0106260822.75f7b24_at_posting.google.com...
> Hi Guys,
>
> Could you guys give me some hints for following question?
> How to check how many rows have been processed while running a long
> run insert query?
> I want to monitor the increasing row number.
>
> Thank you in advance.
>
> Frank
>
Received on Tue Jun 26 2001 - 12:53:39 CDT