select addredd,hash_value from v$sqlarea where sql_text like 'select * from test%'

07000000C1D116C0 4201503884

exec dbms_shared_pool.keep('0700000089F6A2D8,1759984293','c');

alter system flush shared_pool;

select first_load_time,last_load_time from v$sql where hash_value=1759984293

2007-05-24/14:52:44 2007-05-24/14:52:44

成功。

其他：dbms_shared_pool.sizes(100)单位是K

[@more@]

ITPub博客

执行计划绑定到内存中，防止被踢出导致的改变。