hey i did

alter session set optimizer_mode=rule ;

and then the querry ran smoothly :-)