SQL Performance (MOSC)

MOSC Banner

Query performance issue after migration

edited Jul 7, 2014 5:00AM in SQL Performance (MOSC) 9 commentsAnswered
Hi Experts,
I migrated our E-Business Suite Database from 10.2.0.4 32-Bit to 11.2.0.3 64-Bit last month.

For some queries, performance is worse after migration. 
Some queries do not complete, where they were used to complete within seconds.
I can use following workaround to execute these queries in migrated database. But it's not practical as there is so many affected custom queries.
ALTER SESSION SET OPTIMIZER_FEATURES_ENABLE='10.2.0.4';

Please help me to track down the issue.

Thanks,
Lakmal

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