DBMS_SHARED_POOL.PURGE is available from 11.1. In 10.2.0.4, it is available through the fix for Bug 5614566. However, the fix is event protected.  You need to set the event 5614566 to make use of purge. Unless the event is set, dbms_shared_pool.purge will have no effect.

Set the event 5614566 in the init.ora to turn purge on.

event=”5614566 trace name context forever”

SQL> select address, hash_value from v$sqlarea where sql_text = ‘select * from dept’;

ADDRESS HASH_VALUE
——– ———-
2671F27C 3599690174

SQL> exec dbms_shared_pool.purge(‘2671F27C,3599690174′,’C’);

PL/SQL procedure successfully completed.

SQL> select address, hash_value from v$sqlarea where sql_text = ‘select * from dept’;

no rows selected