Home » RDBMS Server » Performance Tuning » procedure tunning (merged)
procedure tunning (merged) [message #384772] Thu, 05 February 2009 02:41 Go to next message
mohannksr
Messages: 28
Registered: January 2009
Junior Member
hi,

i am new to the plsql tunning.
any one help in tunning the
attached procedure....?

Regards,
ssm
Re: procedure tunning (merged) [message #385721 is a reply to message #384772] Tue, 10 February 2009 16:35 Go to previous messageGo to next message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
You post 160+ line of your procedure.

1. No TKPROF.
2. No db structure (indexes, tables, etc.).
3. No hard data.

So what do you expect?

Re: procedure tunning (merged) [message #385723 is a reply to message #384772] Tue, 10 February 2009 16:50 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/84315/74940/
which have you tried & what were the results

You have table & provided us no DDL for it.
You have data & provided us no DML for test data.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you
Re: procedure tunning (merged) [message #385831 is a reply to message #385723] Wed, 11 February 2009 05:19 Go to previous messageGo to next message
mohannksr
Messages: 28
Registered: January 2009
Junior Member
sorry for not following the guidelines....

i am new to this forum too...

Re: procedure tunning (merged) [message #385832 is a reply to message #385723] Wed, 11 February 2009 05:21 Go to previous messageGo to next message
mohannksr
Messages: 28
Registered: January 2009
Junior Member
sorry for not following the guidelines....

i am new to this forum too...

i don't have anyother information related to the function...

so the administrator can close the topic...
Re: procedure tunning (merged) [message #385893 is a reply to message #385832] Wed, 11 February 2009 14:28 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
... but you might get that information. So, if the topic is locked, how would you continue the discussion? Open a new topic? Not!
Previous Topic: Using Index hint (merged)
Next Topic: Inconsistent query behaviour
Goto Forum:
  


Current Time: Fri Dec 09 15:43:59 CST 2016

Total time taken to generate the page: 0.41250 seconds