Oracle 12.1.0.2 impdp导入慢诊断

最新推荐文章于 2021-04-08 16:39:47 发布

深圳gg

最新推荐文章于 2021-04-08 16:39:47 发布

阅读量2k

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库

本文链接：https://blog.youkuaiyun.com/stevendbaguo/article/details/86480319

数据库专栏收录该内容

125 篇文章

订阅专栏

本文介绍如何使用Oracle数据库内置工具跟踪DataPump操作的详细步骤，包括通过特定SQL查询获取DataPump会话信息，开启和关闭会话跟踪，以及分析跟踪文件来定位性能瓶颈。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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**