Adaptive feature being dynamically enabled in the query, even after disabling @DB level
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