***UNCHECKED*** Doubt related to the _optimizer_adaptive_plans hint

I have na application that generate dynamics sql statments and uses bind variable.
It run connect at Oracle 12.2 and the instance parameter is as below: optimizer_adaptive_plans boolean TRUE

I am facing some performance issue with these queries because the optimizer is generating several executions plans for the same sql_id.

Does anyone had this scenary and solved it using the hint /*+ OPT_PARAM('_optimizer_adaptive_plans','false') */ ?

Any experience with this hint ?

Regards
Eriovaldo

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