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: 65155
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: Index Entry
Next Topic: Delaying insert...
Goto Forum:

Current Time: Wed Aug 23 22:11:10 CDT 2017

Total time taken to generate the page: 0.01735 seconds