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?