We have an Oracle query in a report that use to run in less than 1 second. Now takes 8 minutes.
- I've tried rebuilding all the indexes it uses. No impact.
- The query has not been changed in months.
- I personally tested the query on both an older clone of the production db and a new clone. It ran fast on the one and slow on the other. So it's real.
- The explain plan on the query is perfect. No reason why it shouldn't be lightning fast.
I'm running out of ideas. Any suggestions?
tkprof
show that time is really being spent?