Hi Friends,
I have a query which is taking different time to complete on each run and also on each instance.
In Dev instance
first time when i run, it takes around 8 mins to complete
second time it takes around 20 mins and different time in the third run
When i run in a different instance, it takes even longer to complete.
There should not be a considerable difference for each run when we are running the same query right?
Also i am running the query in the same session itself.So from the second time onwards, there should be a soft parse only.
When i see the explain plan, it is same in all the cases.
What are the possible reasons for this and how can this be corrected?
Regards,
Sreekanth Munagala