SQL Language (MOSC)

MOSC Banner

First execution of the query is very very slow

edited Mar 10, 2013 9:22PM in SQL Language (MOSC) 3 commentsAnswered
Hi All,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center