Oracle 12.1.0.2 impdp匯入慢診斷

select s.sid,s.SERIAL#,s.EVENT from v$session s where s.MODULE like ‘%Data Pump%’;

199 14 wait for unread message on broadcast channel
–開啟跟蹤其會話10046事件
exec dbms_monitor.session_trace_enable(199,14,true,true);
–等1個小時
–然後關閉跟蹤
exec dbms_monitor.session_trace_disable(199,14);
–取出跟蹤檔案，記住是匯入會話的sid
SELECT p.tracefile
FROM v$ process p, v$ session s
WHERE p.addr = s.paddr
AND s.sid = 199;
SQL ID: bjf05cwcj5s6p
Plan Hash: 0
BEGIN :1 := sys.kupc$que_int.receive(:2); END;
call count cpu elapsed disk query current rows

---

Parse 0 0.00 0.00 0 0 0 0
Execute 619 1.13 3098.25 0 2476 0 0
Fetch 0 0.00 0.00 0 0 0 0

---

total 619 1.13 3098.25 0 2476 0 0
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 2)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
wait for unread message on broadcast channel
619 5.01 3097.44
latch: shared pool 2 0.00 0.00**

---