First execution of the query is very very slow
I have an urgent issue regarding SQL Query Performance. We have recently upgraded our Production database from 11.2.0.2 to 11.2.0.3 to get rid of some bugs but after the upgrade performance of couple of queries has gone down like anything.
Issue 1 (high priority):
------------------------
For Couple of queries first execution of the query is very slow, it’s running for more than 20 mins but if I run the same query second time I am getting the output in 10-11 seconds.
Issue 2:
--------
First execution is very fast but from second executions onward it’s very slow. However after using OPT_PARAM ('_OPTIMIZER_USE_FEEDBACK' 'FALSE') hint, it’s performing better.