flush sqlid shared_pool

DBA may need to flush the shared pool or the cursor of the query.

conn / as sysdba

1)

alter system flush shared_pool;  --- not recommend during the peak hours of the prod..

or,

2)

select sql_text,address, hash_value, executions from v$sqlarea where sql_id = '&sqlid';
exec sys.dbms_shared_pool.purge('&address, &hash_value','c');

-- passing the address and hash_value from the previous query