Re: Subject: Batch load freezes every couple of minutes

Please provide your definition of 'hang'? To see if your processes are still running look in v$sess_io, if the values there are incrementing, then processing is still going on. you need to find out what the processes are doing at the point that they are freezing? Best way is to get a 10046 trace of one of the processes dumped to a file. Another alternative is to use statspack of before the 'hang' and then another snapshot afterward and look at what sql is processing.

you mentioned that the times that you have problems are when you have lock waits. you could have 1 process doing something for a long time and aquiring a lock on a row. the rest of the processes require that row and have to wait for a commit or rollback.

the v$ tables(other than a quick look at v$sess_io) probably won't be helpful here. you need to know exactly what is going on when this occurs.

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