Excessive Hard Parsing with Oracle EE 19 Exadata

With cursor_sharing = SIMILAR (same issue with FORCE)

1) When i issue this statement (in fact generated by an ERP, i cannot change it)

Begin

delete from CDC_out.MSNCCADAPCICINLINK where ida2a2=1;

delete from CDC_out.MSNCCADAPCICINLINK where ida2a2=2;

delete from CDC_out.MSNCCADAPCICINLINK where ida2a2=3;

End;

/

There is 1 sql area created per delete stmt => poor performance

2) When i issue this batch of statements

delete from CDC_out.MSNCCADAPCICINLINK where ida2a2=1;

delete from CDC_out.MSNCCADAPCICINLINK where ida2a2=2;

delete from CDC_out.MSNCCADAPCICINLINK where ida2a2=3;

There is only 1 sql area created for all delete stmt => good performance