Skip to Main Content

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!

What is the possible cause that the same SQL sometimes run very fast and sometimes run very slow in

user7587483Dec 21 2013 — edited Dec 25 2013

Our application is using the oracle as the database, and when running the batch process, it is find that for the same SQL, in most of the times, it can be completed within 2 minutes, but sometimes (once a week or once a month, and it occurs randomly), the SQL take around 30 minutes to be completed. Do anyone know what is the possible cause of this? Will it be the problem of the Oracle?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 22 2014
Added on Dec 21 2013
4 comments
24,194 views