alter system flush shared_pool;

alter system set cursor_sharing='force';

select * from v$db_object_cache where sharable_mem>1000

and (type='PACKAGE' or type='PACKAGE BODY' or type='FUNCTION' or

type='PROCEDURE') and kept='NO';

执行dbms_share_pool.keep('对象名');

select REQUEST_MISSES from v$shared_pool_reserved;

select COMMPONENT,CURRENT_SIZE from V$SGA_DYNAMIC_COMPONENTS;

show parameter sga_target;

show parameter sga_max_size;

alter system set shared_pool_size=150M scope=both;