Home » RDBMS Server » Performance Tuning » 10.2..0..2 (solaris9)
10.2..0..2 [message #352797] Thu, 09 October 2008 11:22 Go to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Hi Experts,
I have to insert 50000 records in production database.
I generated statements with commit after every 1000 inserts.
Is it good idea ??


Regards,
Varun Punj
Re: 10.2..0..2 [message #352798 is a reply to message #352797] Thu, 09 October 2008 11:25 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Big, Bad and Ugly. Smile. That is generic.
I mean, your server may not go down on its knees.
Generally, it is just a bad idea. Depending on your environment, you may
run into other issues.
Meanwhile, 50,000 records is minuscule.

[Updated on: Thu, 09 October 2008 11:32]

Report message to a moderator

Re: 10.2..0..2 [message #352800 is a reply to message #352797] Thu, 09 October 2008 11:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the relation between the title and the question?

Regards
Michel
Re: 10.2..0..2 [message #352801 is a reply to message #352800] Thu, 09 October 2008 12:01 Go to previous message
varunvir
Messages: 363
Registered: November 2007
Senior Member
sorry about that Michel...
Mahesh thanks for your advice.I am going to remove all
the commits now.
Regards,
Varun Punj
Previous Topic: segment tuning
Next Topic: query tuning
Goto Forum:
  


Current Time: Tue Dec 06 08:45:35 CST 2016

Total time taken to generate the page: 0.13985 seconds