PLSQL Procedure 引起 ORA-04030: (pga heap,control file i/o buffer) 和 ORA-04030: (koh-kghu sessi,pmuccst: adt/record) 或 ORA-04030: (koh-kghucall ,pmucalm coll) 的错误
(Doc ID 1626254.1)
Last updated on AUGUST 04, 2018
适用于:
Oracle Database - Enterprise Edition - 版本 11.2.0.1 和更高版本本文档所含信息适用于所有平台
症状
您运行了一个 PL/SQL package 或者 procedure，当进程使用了 4GB 的内存时总是会遇到 ORA-4030 异常。 _PGA_MAX_SIZE 和 PGA_AGGREGATE_TARGET 已经设置到一个大于 4GB 的值了，但是当 4GB 内存被使用时相同的错误仍然持续报出。
错误看起来类似于：
ORA-04030: out of process memory when trying to allocate 82456 bytes (pga heap,control file i/o buffer)
ORA-04030: out of process memory when trying to allocate 16328 bytes (koh-kghu sessi,pmuccst: adt/record)
ORA-04030: out of process memory when trying to allocate 16328 bytes (koh-kghu sessi,pmuccst: adt/record)
- 或者 -
ORA-06500: PL/SQL: storage error
ORA-04030: out of process memory when trying to allocate 16328 bytes (koh-kghucall ,pmucalm coll)
ORA-06512: at line ...
ORA-04030: out of process memory when trying to allocate 16328 bytes (koh-kghucall ,pmucalm coll)
ORA-06512: at line ...
更改
升级数据库到 11.2.0.1 或更高的版本.
原因
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
文档内容
| 症状 |
| 更改 |
| 原因 |
| 解决方案 |
| 参考 |