Home » RDBMS Server » Performance Tuning » Improvong performance of SQL script
Improvong performance of SQL script [message #299010] Fri, 08 February 2008 09:28 Go to next message
aviana
Messages: 101
Registered: July 2007
Senior Member
Hi,

I am attaching here a script, which takes 3 hours to run..There are many records to get deleted alright but I am just wondering somebody can suggest modifications on this script to improve the performance. All suggestions are welcome.Please tell me how can I do performance analysis of this script.
Thanks a lot
Re: Improvong performance of SQL script [message #299011 is a reply to message #299010] Fri, 08 February 2008 09:30 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I move this in Performance forum.

Read OraFAQ Forum Guide and How to Identify Performance Problem and Bottleneck and provide the usual information for tuning.

Of course, the answer is don't do it with cursor loop.

Regards
Michel

[Updated on: Fri, 08 February 2008 09:32]

Report message to a moderator

Previous Topic: Tool/method for detecting changed executions plans
Next Topic: Delaying insert...
Goto Forum:
  


Current Time: Fri Dec 02 20:30:44 CST 2016

Total time taken to generate the page: 0.11039 seconds