Advanced Collections - EBS (MOSC)

MOSC Banner

SQL performance issues after upgrading from 10gR2 to 11gR2

edited Apr 15, 2016 5:12AM in Advanced Collections - EBS (MOSC) 1 commentAnswered

We are using Oracle EBS R12 and our Application Node at  R121.3  and our  database node at 10.2.0.4 for a few years without any performance issues. Now due to 10gR2 support ended  issue we upgrade our database from 10gR2 to 11gR2. We upgraded the database to 11gR2 in test environment and noticed performance issues. Many SQL would execute in seconds on 10gR2, and the same SQL took time to execute in 11gR2. I set the optimizer_features_enable=10.2.0.4 and restarted the database and everything went back to normal.

If I keep the optimizer_features_enable=10.2.0.4 permanantly, does this mean that all the SQL will use the 10gR2 optimizer in the 11gR2 instance and not the 11gR2 optimizer?

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

EBS Collections Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center