原因分析:
大量的硬解析出现,产生大量小的free chunk
突然出现大的sql
1.临时方法
alter system flush shared_pool;
2.共享SQL
alter system set cursor_sharing='force';
3.
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('对象名');
4.保留区
select REQUEST_MISSES from v$shared_pool_reserved;
5.增加share pool=的空间
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;