Home » RDBMS Server » Performance Tuning » Procedure code taking longer time to execute (Oracle 10.2.0.2.0 , Unix)
Procedure code taking longer time to execute [message #505687] Wed, 04 May 2011 09:39 Go to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Hi,

There are 2 applications A and B. I am able to execute a procedure code in 2 seconds in 'B' application whereas in 'A' application it is taking 2 minutes to execute the code.There is a dblink created between 2 applications.

Can anyone tell me why it is taking 2 minutes longer than B application and how to resolve it?


Thanks

Report message to a moderator

Re: Procedure code taking longer time to execute [message #505690 is a reply to message #505687] Wed, 04 May 2011 09:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Can anyone tell me why it is taking 2 minutes longer than B application
Things are different

>and how to resolve it?
ALTER SESSION SET SQL_TRACE=TRUE
use tkprof to see where time is being spent

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Procedure code taking longer time to execute [message #505691 is a reply to message #505690] Wed, 04 May 2011 09:49 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member
There are 2 applications A and B. I am able to execute
a procedure code in 2 seconds in 'B' application
whereas in 'A' application it is taking 2 minutes
to execute the code.There is a dblink created between
2 applications.

Can anyone tell me why it is taking 2 minutes longer
than B application and how to resolve it?


Thanks

Report message to a moderator

Re: Procedure code taking longer time to execute [message #505692 is a reply to message #505691] Wed, 04 May 2011 09:50 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Can anyone tell me why it is taking 2 minutes longer than B application
Things are different

>and how to resolve it?
ALTER SESSION SET SQL_TRACE=TRUE
use tkprof to see where time is being spent

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Previous Topic: Adding +0 and -0 to a number predicate produces differents plans.
Next Topic: Elapsed time
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 14:53:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.