在AIX下安装的Oracle数据库9.2.0.6,从错误日志中检查到ORA-04030错误,其信息如下:
ORA-04030: out of process memory when trying to allocate 968 bytes (callheap,temporary memory)
ORA-02063: preceding line from JDGFC
ORA-02063: preceding 2 lines from CBJD_FIN
查Oracle错误信息说明如下:
ORA-04030 out of process memory when trying to allocate string bytes (string,string)
Cause: Operating system process private memory has been exhausted.
Action: See the database administrator or operating system administrator to increase process memory quota. There may be a bug in the application that causes excessive allocations of process memory space.
解决过程:
1、缩小SGA,未起到作用
2、缩小pga_aggregate_target,未起到作用
3、缩小SORT_AREA_SIZE,未起到作用
4、检查页面使用,才9%
5、用ulimit -a 检查看了,发现有内存限制
zbdq_b#ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes)