select addredd,hash_value from v$sqlarea where sql_text like 'select * from test%'
07000000C1D116C0 4201503884exec 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博客 ” ,链接:http://blog.itpub.net/561839/viewspace-916138/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/561839/viewspace-916138/