Home » RDBMS Server » Performance Tuning » Parallel inserts (Oracle 10g,Rel 2 ,Linux AS4)
Parallel inserts [message #349642] Mon, 22 September 2008 08:22 Go to next message
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 .

Re: Parallel inserts [message #349650 is a reply to message #349642] Mon, 22 September 2008 09:00 Go to previous message
Michel Cadot
Messages: 65085
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.

Previous Topic: Query taking long time
Next Topic: v$sess_io info is not changing.
Goto Forum:

Current Time: Sun Jul 23 16:13:27 CDT 2017

Total time taken to generate the page: 0.19436 seconds