OraFAQ Forum: Performance Tuning » help in tuning procedure

Home » RDBMS Server » Performance Tuning » help in tuning procedure

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

help in tuning procedure [message #343902]

Thu, 28 August 2008 07:29

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

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: help in tuning procedure [message #344018 is a reply to message #343902]

Thu, 28 August 2008 10:45

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is wrong?

Regards
Michel

Report message to a moderator

Re: help in tuning procedure [message #344186 is a reply to message #344018]

Fri, 29 August 2008 00:55

trupti111
Messages: 29
Registered: August 2008
Location: navi mumbai

Junior Member

it is taking 15 min to execute

Report message to a moderator

Re: help in tuning procedure [message #344188 is a reply to message #344186]

Fri, 29 August 2008 00:59

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: help in tuning procedure [message #344190 is a reply to message #344188]

Fri, 29 August 2008 01:03

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

Report message to a moderator

Re: help in tuning procedure [message #344334 is a reply to message #343902]

Fri, 29 August 2008 07:29

michael_bialik
Messages: 621
Registered: July 2006

Senior Member

Post TKPROF.

Report message to a moderator

Re: help in tuning procedure [message #345874 is a reply to message #343902]

Fri, 05 September 2008 03:19

trupti111
Messages: 29
Registered: August 2008
Location: navi mumbai

Junior Member

thanks

Report message to a moderator

Previous Topic:	to determine join order for tuning
Next Topic:	lobg running query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 22:05:57 CST 2024