trace the expdp log(跟踪EXPDP日志)
来源:互联网 发布:阿里云 全民云计算 编辑:程序博客网 时间:2024/06/10 03:55
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
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
- trace the expdp log(跟踪EXPDP日志)
- trace the expdp log(跟踪EXPDP日志)
- expdp
- expdp
- EXPDP
- expdp ORA-39070: Unable to open the log file
- dul实验(expdp)
- expdp和impdp会带着表的supplemental log
- impdp或expdp报错ORA-39002: invalid operation,ORA-39070: Unable to open the log file
- expdp,impdp
- Exp, expdp
- expdp使用
- expdp&impdp
- expdp, impdp
- expdp工具
- expdp/EXP
- expdp/impdp
- expdp kill_job
- ai透明切片
- flex4 -- 如何自动生成get和set方法,以及使用
- eWebeditor在IE8、IE9中插入图片按钮不能使用问题的解决方法
- 索引的创建及使用(sqlserver 2000)
- 百度快照不更新的几个原因
- trace the expdp log(跟踪EXPDP日志)
- JSON入门
- ubuntu 基本命令 备份
- 第三方Push服务:Urban Airship
- GrailsGuide_1_Configuration
- Socket I/O模型之异步选择(WSAAsyncSelect)
- 实现业务系统中的用户权限管理--设计篇 .
- http://poj.org/problem?id=2186&&强连通分量
- 采集网页选定部分全攻略