AIX下报错ORA-04030问题

来源：互联网发布：树莓派 linux模拟器编辑：程序博客网时间：2024/05/08 08:35

在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)         131072
     stack(kbytes)        32768
     memory(kbytes)       327680
     coredump(blocks)     2097151
     nofiles(descriptors) 2000

才32M，改成了320M，就好了，<===修改/etc/security/limits文件的rss内容

java.sql.SQLException: ORA-04030: out of process memory when trying to allocate 4186152 bytes (QERHJ hash-joi,QERHJ list array)

多次检查无果；

在/etc/security/limits中加入：

oracle:

data=-1

stack=-1