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
Messages: 103
Registered: July 2007
Senior Member

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: 64953
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.


[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 Jun 23 15:53:07 CDT 2017

Total time taken to generate the page: 0.31379 seconds