Oracle: To delete hash value

Multiple execution plans

 To delete hash_value: 

SQL> select hash_value, plan_hash_value from v$sql where sql_id='fptdzyv3nqtad'; 

HASH_VALUE PLAN_HASH_VALUE 

---------- --------------- 

1411591584               0 

  

SQL> select address, hash_value from v$sqlarea where sql_id='fptdzyv3nqtad'; 

ADDRESS          HASH_VALUE 

---------------- ---------- 

00000004E4F48B20 1411591584 

  

SQL> exec dbms_shared_pool.purge('0000000AEFA6CBE0,1411591584','C'); 

PL/SQL procedure successfully completed. 

 ---- ‘C’ (for cursor) or ‘S’ (for SQL)

SQL> select address, hash_value from v$sqlarea where sql_id='fptdzyv3nqtad'; 

no rows selected 

  

SQL> select hash_value, plan_hash_value from v$sql where sql_id='fptdzyv3nqtad'; 

no rows selected 

 

SQL> select sql_handle, plan_name, enabled, accepted, fixed from dba_sql_plan_baselines; 

  

SQL_HANDLE 

-------------------------------------------------------------------------------- 

PLAN_NAME 

-------------------------------------------------------------------------------- 

ENA ACC FIX 

--- --- --- 

SQL_7470c44ba3023c80 

SQL_PLAN_78w649fjh4g40a2ab08d4 

YES YES NO