Hi all,
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