OraFAQ Forum: Performance Tuning » procedure tunning (merged)

Home » RDBMS Server » Performance Tuning » procedure tunning (merged)

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

procedure tunning (merged) [message #384772]

Thu, 05 February 2009 02:41

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

Attachment: function2.txt
(Size: 6.05KB, Downloaded 1303 times)

Report message to a moderator

Re: procedure tunning (merged) [message #385721 is a reply to message #384772]

Tue, 10 February 2009 16:35

michael_bialik
Messages: 621
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?

Report message to a moderator

Re: procedure tunning (merged) [message #385723 is a reply to message #384772]

Tue, 10 February 2009 16:50

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

Report message to a moderator

Re: procedure tunning (merged) [message #385831 is a reply to message #385723]

Wed, 11 February 2009 05:19

mohannksr
Messages: 28
Registered: January 2009

Junior Member

sorry for not following the guidelines....

i am new to this forum too...

Report message to a moderator

Re: procedure tunning (merged) [message #385832 is a reply to message #385723]

Wed, 11 February 2009 05:21

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...

Report message to a moderator

Re: procedure tunning (merged) [message #385893 is a reply to message #385832]

Wed, 11 February 2009 14:28

Littlefoot
Messages: 21823
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!

Report message to a moderator

Previous Topic:	Using Index hint (merged)
Next Topic:	Inconsistent query behaviour

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 18:40:20 CST 2024