SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Stored Procedure is taking too long time to Execute.

838309Feb 18 2011 — edited Feb 18 2011

Hi all,

I have a stored procedure which executes in 2 hr in one database, but the same stored procedure is taking more than 6 hour in the other database.

Both the database are in oracle 11.2

Can you please suggest what might be the reasons.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 18 2011

Added on Feb 18 2011

#performance

13 comments

4,732 views