暂无图片
暂无图片
1
暂无图片
暂无图片
暂无图片

expdp遭遇ORA-04030 (kxs-heap-c,qkkele)错误的解决

原创 11 0 2023-07-24
342

环境描述:

1)aix 7.1,内存16g

2)ORACLE 11.2.0.3 单实例,测试数据库

3)  sga_max_size,sga_target设置为6G左右

     pga_aggregate_target设置为1.5G


expdp遇到以下报错:


Mon Jul 17 15:28:30 2023

Errors in file /oracle/app/oracle/diag/rdbms/smis1/xxxx/trace/xxxx_dm00_60358658.trc  (incident=23195):

ORA-31671: Worker process DW00 had an unhandled exception.

ORA-04030: out of process memory when trying to allocate 2136 bytes (kxs-heap-c,qkkele)

ORA-06512: at "SYS.KUPW$WORKER", line 1838

ORA-06512: at line 2

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Mon Jul 17 15:28:36 2023

Sweep [inc][23195]: completed


1)尝试修改aix的limit的几个参数,未解决。

2)检查metalink,未找到 关键字为(kxs-heap-c,qkkele)的案例。

3)最终通过加大pga_aggregate_target到4G,解决了。


SQL> alter system set memory_max_target=10g scope=spfile; 

System altered.

SQL> alter system set  memory_target =10g scope=spfile;

System altered.

SQL> shut immediate

Database closed.

Database dismounted.

ORACLE instance shut down.


SQL> startup 

ORACLE instance started.

Total System Global Area 1.0689E+10 bytes

Fixed Size                  2230912 bytes

Variable Size            6643778944 bytes

Database Buffers         4026531840 bytes

Redo Buffers               16932864 bytes

Database mounted.

Database opened.

SQL> SQL>

SQL>

SQL>  alter system set pga_aggregate_target=4096m scope=both;

 System altered.



「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论