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
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
Michel Cadot
Messages: 64133
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
Previous Topic: Query taking long time
Next Topic: v$sess_io info is not changing.
Goto Forum:
  


Current Time: Thu Dec 08 04:02:45 CST 2016

Total time taken to generate the page: 0.45960 seconds