ORA-04030: out of process memory when trying to allocate

最新推荐文章于 2024-06-14 11:23:58 发布

wonder_2012

最新推荐文章于 2024-06-14 11:23:58 发布

阅读量7.7k

点赞数

分类专栏： Troubleshooting

本文链接：https://blog.csdn.net/wonder_2012/article/details/23289021

版权

这篇博客记录了在11.2.0.1的Oracle数据库中遇到ORA-04030错误的过程，即尝试分配内存时耗尽进程内存。博主检查了数据库配置，发现PGA设置过小，尝试调整SGA和PGA的参数，但问题仍然存在。最终，通过创建新的pfile，调整控制文件路径，增加备用控制文件，并重新启动数据库，解决了问题。

摘要由CSDN通过智能技术生成

今天发现dg 11.2.0.1备库里alter.log里报

RFS[11]: Selected log 4 for thread 1 sequence 14934 dbid 1020656503 branch 787682297
Wed Apr 09 08:00:38 2014
Archived Log entry 9696 added for thread 1 sequence 14933 ID 0x3d183f75 dest 1:
Wed Apr 09 08:00:40 2014
Media Recovery Log /data/ora_archive/1_14933_787682297.dbf
Wed Apr 09 08:01:24 2014
Media Recovery Waiting for thread 1 sequence 14934 (in transit)
Wed Apr 09 08:10:50 2014
Errors in file /u01/app/diag/rdbms/hz_dg2/hz/trace/hz_mmon_22604.trc (incident=44924):
ORA-04030: out of process memory when trying to allocate 496 bytes (Alloc statemen,alloc bind hndl)
Incident details in: /u01/app/diag/rdbms/hz_dg2/hz/incident/incdir_44924/hz_mmon_22604_i44924.trc
Errors in file /u01/app/diag/rdbms/hz_dg2/hz/trace/hz_mmon_22604.trc (incident=44925):
ORA-04030: out of process memory when trying to allocate bytes (,)
Incident details in: /u01/app/diag/rdbms/hz_dg2/hz/incident/incdir_44925/hz_mmon_22604_i44925.trc
Wed Apr 09 08:10:57 2014
Trace dumping is performing id=[cdmp_20140409081057]
Trace dumping is performing id=[cdmp_20140409081058]
Wed Apr 09 08:10:58 2014
Sweep [inc][44925]: completed
。。。。。。。。。。。。。。。。。。。。。。。。。。。

Errors in file /u01/app/diag/rdbms/hz_dg2/hz/trace/hz_mmon_22604.trc (incident=45625):
ORA-04030: out of process memory when trying to allocate 1752 bytes (Alloc environm,alloc statement hndl)
Errors in file /u01/app/diag/rdbms/hz_dg2/hz/trace/hz_mmon_22604.trc (incident=45626):
ORA-04030: out of process memory when trying to allocate bytes (,)
Errors in file /u01/app/diag/rdbms/hz_dg2/hz/trace/hz_mmon_22604.trc (incident=45627):
ORA-04030: out of process memory when trying to allocate 432 bytes (session heap,kqdAlloc)
Wed Apr 09 08:59:14 2014
Sweep [inc][45627]: completed
Sweep [inc][45626]: completed
Sweep [inc][45625]: completed

more /u01/app/diag/rdbms/hz_dg2/hz/incident/incdir_44924/hz_mmon_22604_i44924.trc
*** 2014-04-09 08:14:19.640
44% 1737 MB, 6868633 chunks: "mark "
Alloc statemen ds=0x2abc9dbe3980 dsprt=0x2abb9e0ee8b0
41% 1640 MB, 981240 chunks: "mark "
Alloc environm ds=0x2abb9e0ee8b0 dsprt=0x2abb9e0c5fa0
13% 515 MB, 1046650 chunks: "free memory "
Alloc statemen ds=0x2abc9dbe3980 dsprt=0x2abb9e0ee8b0
2% 91 MB, 981234 chunks: "permanent memory "
Alloc statemen ds=0x2abc9dbe3980 dsprt=0x2abb9e0ee8b0
0% 616 KB, 24 chunks: "permanent memory "
pga heap ds=0xa99d240 dsprt=(nil)
0% 296 KB, 1 chunk : "kfk_kfkio_freeq