Re: how to monitor the progress of inserts

Sonja Šehović wrote:

>Hi!
>
>Oracle 9.2.0.4 on AIX 5.2
>We are nserting large amonts of data in one session without commiting =
>because of business reasons.=20
>So, I'm wondering is there a way to monitor progress of this inserts?
>
>
>

Sonja, you can use autonomous transactions to establish a counter which will commit separately,
as the transaction is progressing. You will know that you are successful when queries start returning
with ora-1555.

-- 
Mladen Gogala
Oracle DBA
Ext. 121


--
http://www.freelists.org/webpage/oracle-l