Parallel inserts [message #349642] |
Mon, 22 September 2008 08:22 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
rsreddy28
Messages: 295 Registered: May 2007
|
Senior Member |
|
|
Hi All,
I've a small doubt regarding DML Transactions . What will be the precautions that need to be taken while doing any kind of Parallel Inserts or any kind of Batch processing.
Please let me know .
Regards,
Raj
|
|
|
Re: Parallel inserts [message #349650 is a reply to message #349642] |
Mon, 22 September 2008 09:00 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68678 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Have you the IO bandwith, the CPU power?
You must commit after the parallel DML statement before reusing the table.
Regards
Michel
|
|
|