High Parse with my sql

Hi All,

I have a query which is running much slower in 12c vs 11g. The Plan suggests is different in both instances, the table counts have been checked as have stats.

I have traced the 12c query and tkprof suggests a huge number of parse  occurred and this took up most of the time during the query execution.

I am unsure how to investigate why it is doing this so would like some pointers if possible.

I understand the parse is because the sql is not found.

Does anyone have any pointers.  I have also noticed the 12c trace shows a number of dynamic sampling occurring (my database has the default set). I am unsure if this might also be causing the issue.