Home » RDBMS Server » Performance Tuning » help in tuning procedure
help in tuning procedure [message #343902] Thu, 28 August 2008 07:29 Go to next message
trupti111
Messages: 29
Registered: August 2008
Location: navi mumbai
Junior Member
Please help me in tuning following procedure

Procedure code removed by LF, as requested by Trupti111:

Reported By: trupti111
On: Fri, 05 September 2008 10:09 In: RDBMS Server Performance Tuning help in tuning procedure
Reason: Delete this procedure as it is publicly displayed

[Updated on: Fri, 05 September 2008 03:12] by Moderator

Report message to a moderator

Re: help in tuning procedure [message #343957 is a reply to message #343902] Thu, 28 August 2008 09:03 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above
Re: help in tuning procedure [message #344018 is a reply to message #343902] Thu, 28 August 2008 10:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is wrong?

Regards
Michel
Re: help in tuning procedure [message #344186 is a reply to message #344018] Fri, 29 August 2008 00:55 Go to previous messageGo to next message
trupti111
Messages: 29
Registered: August 2008
Location: navi mumbai
Junior Member
it is taking 15 min to execute
Re: help in tuning procedure [message #344188 is a reply to message #344186] Fri, 29 August 2008 00:59 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
trupti111 wrote on Thu, 28 August 2008 22:55
it is taking 15 min to execute


So you say.

Provide DDL & DML so others can reproduce your results.
Re: help in tuning procedure [message #344190 is a reply to message #344188] Fri, 29 August 2008 01:03 Go to previous messageGo to next message
trupti111
Messages: 29
Registered: August 2008
Location: navi mumbai
Junior Member
I tried using bulk collect instead of cursor for loop but toad is hanging when i execute the procedure......n bulk collect also taking long time
Re: help in tuning procedure [message #344334 is a reply to message #343902] Fri, 29 August 2008 07:29 Go to previous messageGo to next message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
Post TKPROF.
Re: help in tuning procedure [message #345874 is a reply to message #343902] Fri, 05 September 2008 03:19 Go to previous message
trupti111
Messages: 29
Registered: August 2008
Location: navi mumbai
Junior Member
thanks
Previous Topic: to determine join order for tuning
Next Topic: lobg running query
Goto Forum:
  


Current Time: Fri Dec 09 04:09:09 CST 2016

Total time taken to generate the page: 0.14627 seconds