ORA-31671: WORKER PROCESS DW00 HAD AN UNHANDLED EXCEPTION
Datapump, ORA-31671
A datapump worker dies with error ORA-04030 while importing statistics.
SYMPTOMPS
A datapump import failed with the following error
impdp system/password schemas=XXCDB NETWORK_LINK=PRODDB DIRECTORY=DROPZONE LOGFILE=logfile.log
...
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-04030: out of process memory when trying to allocate 16048 bytes (session heap,kuxLpxAlloc)
ORA-06512: at "SYS.KUPW$WORKER", line 1838
ORA-06512: at line 2
Processing object type SCHEMA_EXPORT/JOB
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
There are sufficient SGA/PGA in the database.
SOLUTION
To eliminate the error with a datapump worker, exclude statistics during an import
impdp system/password schemas=XXCDB NETWORK_LINK=PRODDB DIRECTORY=DROPZONE LOGFILE=logfile.log EXCLUDE=STATISTICS
NOTE
It skips tables statistics but collects indexes statistics.
When the import is completed, manually gather schema statistics by executing the DBMS_STATS.GATHER_SCHEMA_STATS procedure
EXEC DBMS_STATS.GATHER_SCHEMA_STATS('XXCDB');
REFERENCES
EXCLUDE=STATISTICS Or EXCLUDE=INDEX_STATISTICS During Datapump Import Still Analyzes The Indexes (Doc ID 793585.1)
Written At
22 JULY 202016:40
OEL Release
7.2 x64
Database Release
11.2.0.4
Tags In
Share
- Accounts
- Auditing
- AWR
- Bash Scripts
- Datapump
- Default Category
- Demos
- Directory Objects
- Environment Variables
- Initialization Parameters
- Iptables
- Java Program
- Memory Usage
- Metadata API
- Networker
- NLS Settings
- Optimizer Statistics
- ORA-00942
- ORA-01031
- ORA-01720
- ORA-28001
- ORA-31671
- Oracle Database
- Oracle Enterprise Manager
- Performance Tunning
- Postfix
- Privilegies
- Processes
- Queries
- Red Hat Enterprise Linux
- Redo Logs
- Session Tracing
- Sessions
- SQL Trace
- SQLPlus
- Statspack
- Tablespaces
- UTL_FILE
- UTL_FILE_DIR
- Wait Events
- Yum