Hello.
I use dbms_sqldiag.create_sql_patch with hint that contains SEL$07BDC5B4 query block for TBL@SEL$5. It's different for different sql text. Do I need to fix plan with dbms_spm.load_plans_from_cursor_cache after creating patch? if so how I can reproduce changing sql_id (and query block name) without changing sql query. I tried alter system flush shared_pool; DBMS_SHARED_POOL.PURGE; restarting database with no success: sql_id is getting restored in v$sql after calling sql.
Thanks in advance.