SQL Performance (MOSC)

MOSC Banner

After upgrading oracle rac from 11.2.0.3 to 11.2.0.4, there was a sql execution performance issue

Recently upgraded my database from redhat linux 6.9+11.2.0.3 rac to redaht linux 7.8+11.2.0.4 rac, in the testing process found that most of the sql is still executed according to the original execution plan, but there is a major sql call a lot of views to change the execution plan resulting in performance degradation, in the source environment only takes 2 milliseconds, in the upgraded environment takes 2 minutes, I have collected statistics, But the execution is still very slow, how do I solve this problem?

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