Slow impdp

select v.status,
v.sid,
v.serial#,
io.block_changes,
v.event,
v.module
from v$sess_io io,
v$session v
where io.sid = v.sid
and v.saddr in (
select saddr
from dba_datapump_sessions)
order by sid;

STATUS SID SERIAL# BLOCK_CHANGES EVENT MODULE
-------- ---------- ---------- ------------- -------------------------------------------------- -------------------------
ACTIVE 151 54669 5488 wait for unread message on broadcast channel udi@PDWHDBS01 (TNS V1-V3)
ACTIVE 414 22229 14136 wait for unread message on broadcast channel Data Pump Master
ACTIVE 441 48991 8616526 Datapump dump file I/O Data Pump Worker
ACTIVE 471 12403 6647720 Streams AQ: enqueue blocked on low memory Data Pump Worker
ACTIVE 495 64739 7939268 wait for unread message on broadcast channel Data Pump Worker
ACTIVE 525 877 6414540 wait for unread message on broadcast channel Data Pump Worker

EXPDP And IMPDP Slow Performance In 11gR2 and 12cR1 And Waits On Streams AQ: Enqueue Blocked On Low Memory (Doc ID 1596645.1)
Checklist For Slow Performance Of DataPump Export (expdp) And Import (impdp) (Doc ID 453895.1)
DataPump Export Fails With Error ORA-39826 (Doc ID 1546646.1)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s