資料泵匯出出現ORA-4030錯誤

客戶Oracle 10.2.0.3環境，在匯出是碰到ORA-4030錯誤。

錯誤資訊為：

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name “DW01” prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-04030: out of process memory when trying to allocate 4108 bytes (PLS non-lib hp.pdzgM60_Make)
ORA-06512: at “SYS.KUPC$QUEUE_INT”, line 277
ORA-06512: at “SYS.KUPW$WORKER”, line 1311
ORA-04030: out of process memory when trying to allocate 65036 bytes (kxs-heap-c,KQL tmpbuf)
ORA-06512: at “SYS.KUPW$WORKER”, line 13249
ORA-06512: at “SYS.KUPW$WORKER”, line 14923
ORA-06512: at “SYS.KUPW$WORKER”, line 6293
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.DISPATCH_WORK_ITEMS while calling DBMS_METADATA.FETCH_XML_CLOB [PROCOBJ:“USER1”.“PROC_SCENAR2”]
ORA-06512: at “SYS.KUPW$WORKER”, line 6988
ORA-04030: out of process memory when trying to allocate 4108 bytes (PLS non-lib hp.pdzgM60_Make)
ORA-04030: out of process memory when trying to allocate 16396 bytes (koh-kghu sessi,pl/sql vc2)
ORA-06512: at “SYS.KUPF$FILE”, line 2901
ORA-06512: at “SYS.KUPW$WORKER”, line 2301
ORA-04030: out of process memory when trying to allocate 16396 bytes (koh-kghu sessi,pl/sql vc2)
ORA-06512: at “SYS.KUPW$WORKER”, line 2

Job “USER1”.“SYS_EXPORT_SCHEMA_01” stopped due to fatal error at 10:50:29

Oracle在匯出資料字典後設資料時出現了異常，這顯然屬於Oracle的bug。查詢MOS，發現大量類似的描述，其中以DataPump Export (EXPDP) Terminates With Error ORA-4030 [ID 1368462.1]的描述最為接近。

Oracle給出了三種接近方案，可以設定隱含引數_use_realfree_heap=TRUE和 _realfree_heap_pagesize_hint=262144，這是避免PL/SQL程式導致ORA-4030錯誤的；另外就是在EXPDP的時候指定EXCLUDE=PROCACT_SYSTEM或EXCLUDE=PROCACT_SCHEMA，對當前的情況而言，這個方法應該是最適合的；最後一個方法是設定作業系統核心引數vm.max_map_count=300000。