alter session set "_optimizer_filter_pred_pullup"=false; alter system set "_optimizer_filter_pred_pullup"=false; OK