One of our applications fires queries that execute slowly first time, but when I execute the same query again , it is faster . By not being able to find out WHY the query is slow, I also can't find a solution. We've been struggling with this issue for quite some time we are still running on Oracle 11Gr2 standard edition:
execution plan first run:
statistics_avant.txt (115.96 KB)execution plan second run:
statistics_apres.txt (116.53 KB)Please advise.
Thanks