Re: Simultaneous long sql operations

The other item to consider is your redo log space. If they're running in parallel, the redo log space has to be able to handle all the transactions from both before coming back to where the first one started.

If they're roughly the same size, you need about double the redo log size to run them in parallel (unless, of course, there is another reason for it to be larger.) Received on Wed Mar 02 2005 - 09:00:56 CST