Change the OPTIMIZER_MODE to RULE in init.ora file.