OraFAQ Forum: SQL & PL/SQL » Oracle Stored procedure takes long time to initiate / execute

Home » SQL & PL/SQL » SQL & PL/SQL » Oracle Stored procedure takes long time to initiate / execute - (from package) (Oracle 11.2.0.3, Linux x86 64)

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

Oracle Stored procedure takes long time to initiate / execute - (from package) [message #644112]

Wed, 28 October 2015 05:23

hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA

Member

Hi,

In one of the database when developer tries to execute the Procedure through Package it shows that " it connected to database" but after that just
to initiate the execution it takes approximately 45 minutes.
The same procedure used to take 15 minutes previously.

Also, I tried to execute the same procedure in another database it works fine and completes within 15 minutes.

Fyi.... both the database objects are analyzed recently also data volume are same.

I don't have enough information from application team to provide so sorry for the same.

Can it be possible to help me with the possible cause of this slowness ?

Many thanks in advance.

Regards,
Hitesh

Report message to a moderator

Re: Oracle Stored procedure takes long time to initiate / execute - (from package) [message #644116 is a reply to message #644112]

Wed, 28 October 2015 05:47

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

Senior Member
Account Moderator

Quote:

Can it be possible to help me with the possible cause of this slowness ?

Can it be possible a doctor cures a patient without seeing him and having no more information that he feels ill?

Report message to a moderator

Re: Oracle Stored procedure takes long time to initiate / execute - (from package) [message #644117 is a reply to message #644116]

Wed, 28 October 2015 05:55

hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA

Member

Hi,

Sure, will help you with more information on the same soon, can you please let me know what all details required?

Thanks in advance.

Report message to a moderator

Re: Oracle Stored procedure takes long time to initiate / execute - (from package) [message #644128 is a reply to message #644117]

Wed, 28 October 2015 07:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

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

Previous Topic:	Coping one cursor results into another cursor
Next Topic:	Insert, delete and update At a time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 10 12:54:23 CDT 2026