query taking a long time

following sql takes a long time to be executed. I have seen that the query was the whole time on CPU.
I checked one execute plan and I found a lot of NLs and the E-Rows is much less than the A-Rows.
I gathered the data dictionary and fixed objects statistics but it doesn't help. We are using 12.1.0.2  

any Idea?  

Best regards
Ahmed  



--
http://www.freelists.org/webpage/oracle-l




image/png attachment: MljcuqFf.png