OraFAQ Forum: SQL & PL/SQL » Calling Procedure

Home » SQL & PL/SQL » SQL & PL/SQL » Calling Procedure (11g)

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

Calling Procedure [message #642739]

Thu, 17 September 2015 14:09

P1Oracle
Messages: 60
Registered: August 2014
Location: Hyderabad

Member

Hi everyone,
What might be the reason as much time taking when i call procedure from package..

BEGIN
XX_TEST_PKG.MAIN;
END;
/

Report message to a moderator

Re: Calling Procedure [message #642741 is a reply to message #642739]

Thu, 17 September 2015 14:37

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

It could be:
a) The procedure is doing lots of things
b) The procedure is doing one thing that takes a long time
c) a and b
d) something else
e) c and d

Do you really think there are only one or two things that procedures can possibly do that take a long time? The list is practically endless.
You need to show us what the procedure does for any of us to even think of taking a guess at what the problem is.

Report message to a moderator

Re: Calling Procedure [message #642742 is a reply to message #642739]

Thu, 17 September 2015 14:45

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

Senior Member
Account Moderator

Your SGA is too small, increase it this has worked in your previous topic.

[Updated on: Thu, 17 September 2015 14:46]

Report message to a moderator

Re: Calling Procedure [message #642743 is a reply to message #642739]

Thu, 17 September 2015 14:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

thiruvari wrote on Thu, 17 September 2015 12:09

Hi everyone,
What might be the reason as much time taking when i call procedure from package..
BEGIN
XX_TEST_PKG.MAIN;
END;
/

ORAFAQ tuning below -
Since NOBODY can optimize SQL just by looking at it, we need a few more details.
http://www.orafaq.com/forum/mv/msg/84315/433888/#msg_433888
Please refer to URL above & be sure to provide the details requested:
1) DDL for all tables & indexes
2) EXPLAIN PLAN
3) output from SQL_TRACE & tkprof

Report message to a moderator

Re: Calling Procedure [message #642948 is a reply to message #642742]

Wed, 23 September 2015 07:10

sandeep_orafaq
Messages: 88
Registered: September 2014

Member

Report message to a moderator

Previous Topic:	Rownum
Next Topic:	% with ROWNUM

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 27 15:18:06 CDT 2026