http://www.orapub.cn/posts/1624.html
一、以下在Oracle APP中执行：
1) Set the Profile Option: ‘Initialization SQL Statement – Custom’ at the USER level to the following statement all on one line:
在用户层设置配置文件 Initialization SQL Statement – Custom的值为以下脚本（一般粘帖复制即可）：
begin fnd_ctl.fnd_sess_ctl(”,”,’TRUE’,'TRUE’,'LOG’,'ALTER SESSION SET EVENTS=’||””||’10046 TRACE NAME CONTEXT FOREVER, LEVEL 12′||””); end;
2) Change responsibilities and directly go and reproduce the problem. Before you look for the Trace file, perform: "Help > About Oracle Application" and get the Process_id (VERSION_DATABASE_PROCESS) .Search for the Trace file using this number.
切换到相应职责，重新测试该问题。然后马上执行：(Form)帮助>关于Oracle Applications，找到这一条：“数据库服务器 PID : 23646”（English：Database Server PID : 23646）。记下这个号码，根据该号码去找跟踪文件。
3) Ensure that the profile option is unset before exiting the Application.
关闭EBS应用之前重置以上设置的配置文件，否则会生成一些不必要的跟踪文件。
This is a very important step. If this is not unset, unnecessary trace files would be generated.
二、以下在后台OS中执行：
1）执行环境变量，使能够使用命令sqlplus：
[oracle@ebs /]$ dbenv
2）以sysdba用户进入sqlplus：
[oracle@ebs /]$ sqlplus "/ as sysdba"
SQL*Plus: Release 11.1.0.7.0 – Production on Fri Dec 10 14:47:34 2010
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
3）执行脚本：select value from v$parameter where name like ‘user_dump_dest’; ，返回一个目录值，退出sqlplus，进入该目录：
The trace file will be generated under the directory returned by the following statement:
SQL> select value from v$parameter where name like ‘user_dump_dest’;
VALUE
——————————————————————————–
/u01/oracle/prod/db/tech_st/11.1.0/admin/prod_ebs/diag/rdbms/prod/prod/trace
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ebs /]$ cd /u01/oracle/prod/db/tech_st/11.1.0/admin/prod_ebs/diag/rdbms/prod/prod/trace
[oracle@ebs trace]$
4）根据PID:23646 查找trace文件：
[oracle@ebs trace]$ ls *23646*
prod_ora_23646.trc prod_ora_23646.trm
5）使用命令Tkprof 生成Tkprof trace文件
[oracle@ebs trace]$ tkprof prod_ora_23646.trc【回车】
output = tkprof_23646.trc
TKPROF: Release 11.1.0.7.0 – Production on Fri Dec 10 14:28:12 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
6）重新查询，查看该pid对应的.trc文件，使用ftp 下载到本地。
[oracle@ebs trace]$ ls *23646*
prod_ora_23646.trc prod_ora_23646.trm tkprof_23646.trc
[oracle@ebs trace]$