Home » SQL & PL/SQL » SQL & PL/SQL » performance tunning
performance tunning [message #249764] Thu, 05 July 2007 15:45 Go to next message
Messages: 20
Registered: June 2007
Location: somerset
Junior Member

The procedure which runs at night to update the table 'X'
which is taking around 3 hours to execute.Is it posible to tune which can be exectued in less than a hour.
Please any one can any one go thru the procedure ehich is attached to it and find out whats going on.
Re: performance tunning [message #249768 is a reply to message #249764] Thu, 05 July 2007 16:15 Go to previous messageGo to next message
Messages: 25581
Registered: January 2009
Location: SoCal
Senior Member
I am not about to optimize 1500+ lines of PL/SQL for free.
Especially when you ignored all/most posting guidelines.

You're On Your Own (YOYO)!
Re: performance tunning [message #249793 is a reply to message #249764] Thu, 05 July 2007 21:25 Go to previous message
Messages: 1848
Registered: November 2006
Senior Member
Your procedure contains 11 SQL statements.
You should identify which of them take a long time and then optimize them.

Second sight: 6 of your SQL statements are UPDATEs on the full table.
If they take most of the time you should either fill the updated columns in INSERTs (if possible)
or group the UPDATE statements together (if possible)
or create another table(s) for the columns (if duplicate for many rows)
or not store that columns at all.

[Edit: Added the second paragraph]

[Updated on: Thu, 05 July 2007 21:36]

Report message to a moderator

Previous Topic: Driving table problem
Next Topic: How to transfer 500,000 records from 1 db to another
Goto Forum:

Current Time: Thu Aug 24 02:02:56 CDT 2017

Total time taken to generate the page: 0.07943 seconds