原因分析：

---

大量的硬解析出现，产生大量小的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>1000and (type='PACKAGE' or type='PACKAGE BODY' or type='FUNCTION' ortype='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;