SQL> alter system flush shared_pool;
SQL> select * from emp where empno=7934;
EMPNO ENAME JOB MGR HIREDATE SAL COMM  DEPTNO
7934 MILLER CLERK 7782 23-JAN-82 1300 10
SQL> select * from v$sqltext where sql_text like ‘%from emp%’;
ADDRESS HASH_VALUE SQL_ID COMMAND_TYPE PIECE
—————- ———- ————- ———— ———-
SQL_TEXT
—————————————————————-
07000000223AB1E8 2736814944 gmjgsqfjk0yv0 3 0
select * from emp where empno=:”SYS_B_0″

07000000223B68A0 1745700775 a2dk8bdn0ujx7 3 0
select * from emp

SQL> exec sys.dbms_shared_pool.keep(‘07000000223AB1E8,2736814944′,’c’);

PL/SQL procedure successfully completed.