4 Replies Latest reply: Dec 25, 2013 11: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?


      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?