Re: Subject: Batch load freezes every couple of minutes
- From: ryan_gaffuri@xxxxxxxxxxx
- To: mosicr@xxxxxxxxxx, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 18 Apr 2005 00:56:29 +0000
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
