环境描述:
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;




