4 Replies Latest reply: Dec 25, 2013 9:18 AM by EdStevens RSS

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

user7587483 Newbie
Currently Being Moderated

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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points