SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE? ? 11.2.0.1.0? ? ? Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL> drop table test purge;
SQL> create table test as select * from dba_objects;
SQL> exec dbms_stats.gather_table_stats(user,'test');
SQL> select /*gg*/count(*) from test;
? COUNT(*)
----------
? ? 79747
SQL> col SQL_TEXT format a35
SQL> col HASH_VALUE format a10
SQL> select s.SQL_TEXT, s.ADDRESS, s.HASH_VALUE||''
? ? ? ? ? from v$sqlarea s
? ? ? ? where sql_text like 'select /*gg*/count(*) from test%';
SQL_TEXT? ? ? ? ? ? ? ? ? ? ? ? ? ? ADDRESS? ? ? ? ? ? S.HASH_VALUE||''
----------------------------------- ------------------ --------------------------------
select /*gg*/count(*) from test? ? 0000000300B06D70? 728448230
SQL> exec sys.dbms_shared_pool.purge('0000000300B06D70,728448230','c');
PL/SQL 过程已成功完成。
SQL> select s.SQL_TEXT, s.ADDRESS, s.HASH_VALUE||''
? ? ? ? ? ? ? from v$sqlarea s
? ? ? ? ? ? where sql_text like 'select /*gg*/count(*) from test%';
未选定行