SQL Performance (MOSC)

MOSC Banner

Adaptive feature being dynamically enabled in the query, even after disabling @DB level

edited Jul 27, 2019 5:03AM in SQL Performance (MOSC) 12 commentsAnswered

I have a warehouse DB with Oracle Version 12.1.0.2 ,disabled the adaptive feature in DB level

QL> show parameter adaptive

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

_adaptive_window_consolidator_enable boolean     TRUE

d

_optimizer_adaptive_cursor_sharing   boolean     TRUE

_optimizer_adaptive_plans            boolean     FALSE

_optimizer_nlj_hj_adaptive_join      boolean     TRUE

_optimizer_strans_adaptive_pruning   boolean     TRUE

_px_adaptive_dist_method             string      CHOOSE

optimizer_adaptive_features          boolean     FALSE

optimizer_adaptive_plans             boolean     TRUE

optimizer_adaptive_reporting_only    boolean     FALSE

optimizer_adaptive_statistics        boolean     TRUE

parallel_adaptive_multi_user         boolean     TRUE

but in trace it shows adaptive feature is enabled dynamically, Can any one help, attached the complete trace file

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