Re: how to monitor the progress of inserts
- From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
- To: sonja.sehovic@xxxxxx
- Date: Tue, 01 Feb 2005 10:30:11 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
