ora-04031 share pool问题处理

环境：AIX 5400-09  oracle 10.2.0.1

错误现象：

       在alert中频繁报以下的错误，最终导到客户端连接不上服务器。

Mon Jun 15 20:11:47 2009
Errors in file /oracle/admin/data/bdump/data_j001_5547130.trc:
ORA-12012: error on auto execute of job 344
ORA-04045: errors during recompilation/revalidation of PERFORM.MAXSTOPTIMESTAMP
ORA-04031: unable to allocate 80 bytes of shared memory ("shared pool","unknown object","kksss-heap","kksheq")
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1

 

分析：

       出现SHARED POOL ora-04031的故障主要有以下的原因：

       1、Shared_pool_size尺寸是否够大。该库的SGA为16G，Shared_pool_size为4G，且为10G自动管理。Shared_