获取 Export and Import 的 10046 Trace (Doc ID 258418.1)

Getting 10046 Trace for Export and Import (Doc ID 258418.1)

PURPOSE
-------

Getting 10046 Trace for Export and Import Utilities

 
SCOPE & APPLICATION
-------------------

DBA's and Support Analysts



Getting 10046 Trace for Export and Import Utilities
----------------------------------------------------
 
1] Run command export and let the program prompt you for the options.  运行命令

$ exp system/<PASSWORD>

2] Open another window and attach the debugger as described below.  打开另一个窗口。

Run the following SQL statement to find the session that is running the export. 
运行以下SQL语句以查找正在运行export的会话。

$ sqlplus system/<PASSWORD>

sql> 	select sid,program from 
	v$session where username = 'SYSTEM' 

SID 		PROGRAM 
---------- ------------------------------------------------ 
10 		exp@<HOSTNAME> (TNS V1-V3) <-- Session running export command 

sql> 	select s.sid, p.pid, p.spid 
	from v$session s, v$process p 
	where s.paddr = p.addr and s.sid = 10; 

SID 		PID 		SPID 
---------- ---------- 		--------- 
10		15 		2619 

SPID from the previous query is equivalent to OSPID (operating System process). 
来自上一个查询的SPID等效于OSPID（操作系统进程）。

3] Generate a trace file to Proccess ID 2619

Note:- Use SQLPLUS and connect as sysdba in 9i and higher. 

$ svrmgrl <enter> 

svrmgr> connect internal 

svrmgr> oradebug setospid 2619

svrmgr> oradebug Event 10046 trace name context forever, level 12; 


4] Switch back to the exp/imp windows and enter the parameters and then start the operation.
   切换回exp/imp窗口并输入参数，然后开始操作。
   e.g
   
   FULL=y 
   FILE=file.dmp (or the Parameters used by your export)

   
5] Set the Trace off once you get the Required information or the error.
   一旦获得必填信息或错误，请关闭跟踪。

svrmgr> oradebug Event 10046 trace name context off; 

This will generate a trace file in the udump directory with the Process ID appended.
这将在udump目录中生成Trace文件，并附加进程ID。