Bind Mismatch New Child And Plan Flip

Database Version -19.15.0.0.0

Server- Linux x86 64-bit

Oracle Linux Server release 7.9

Problem :- Sql was experienced performance degradation and plan instability for the 3rd time.

11 BIND Variables are using from APP.

Fix -

1st Time - SQL PROFILE implemented with good PHV and then worked for few days.

2nd Time - Stale stats has been fixed.

3rd Time - Sql plan baseline fixed.

Now query is running fine. But we need to know RCA for this.

Observation:-

Cursor 0 & 1 are getting reparsed with bind mismatch reason from v$sql_child_cursor

We could see 14 entries in that view which says reason for not sharing the cursor is bind mismatch