trace the expdp log（跟踪EXPDP日志）

最新推荐文章于 2023-07-28 10:09:49 发布

iteye_18365

最新推荐文章于 2023-07-28 10:09:49 发布

阅读量328

点赞数

本文介绍如何确认数据是否被快速导出，并提供了一种方法来测量导出时间的差异。通过执行特定的SQL查询获取导出会话的相关信息，设置SQL_TRACE以生成跟踪文件，从而帮助分析导出过程中的性能瓶颈。

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

Can you confirm if the same data was exported quickly before? If so can we know the time difference?

Perform the following and provide the trace files generated:

Ensure there is sufficient space in the udump destination.
Execute the export session.
The following query will give us the sid, serial# and pid of the export session:

set lines 150 pages 100 numwidth 7
col program for a38
col username for a10
col spid for a7
SQL>select s.program, s.sid,
s.status, s.username, d.job_name, p.spid, s.serial#, p.pid
from v$session s, v$process p, dba_datapump_sessions d
where p.addr=s.paddr and s.saddr=d.saddr;

To SQL_TRACE Master Control process with level 8 (Waits):
execute sys.dbms_system.set_ev(sid,serial#,10046,8,''); ---------> enter the export session sid, serial# from the above query. Do this for both the master process and the worker process.
Wait for 20 mins and then disable the trace
To disable:
execute sys.dbms_system.set_ev(sid,serial#,10046,0,'');

-- This results in two trace files in BACKGROUND_DUMP_DEST:
-- Master Process trace file: <SID>_dm<number>_<process_id>.trc
-- Worker Process trace file: <SID>_dw<number>_<process_id>.trc