SQL Performance (MOSC)

MOSC Banner

oracle11.2.0.1 not using optimizer

edited Apr 28, 2017 5:02AM in SQL Performance (MOSC) 2 commentsAnswered

I imported oracle data from 10.2.0.4 to 11.2.0.1 by expdp and impdp after that query time slower than 10g and cost is very height.

but when I use /*+ optimizer_features_enable('11.2.0.1') */ in a statement the time and cost is too low

and then I test in another system by impdp with exclude=statistics, it using optimizer in a query

How to set the database to enable the optimizer?

here the optimizer in my parameter file

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter optimizer;

NAME                                 TYPE        VALUE

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