Oracle Database 12c (12.1.0.2.0)
It looks like that there is some problem in Oracle Execution plan with the above version and if data in the tables changed
like bulk data inserted it get hang and statistics should be gathered ,I didn't notice this problem in earlier releases?
Any way to solve this without manual intervention?