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: 106
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

Report message to a moderator

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: 68665
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jun 27 19:07:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.