Using Profile "Initialization SQL Statement - Custom" to collect sql trace

"Initialization SQL Statement - Custom"常用于Concurrent Request的Sql Trace

1.查询Profile:"Initialization SQL Statement - Custom"，值设置为

Begin fnd_ctl.fnd_sess_ctl('','','TRUE','TRUE','LOG','ALTER SESSION SET TRACEFILE_IDENTIFIER='||''''||'ptian123'||''''||' EVENTS='||''''||'10046 TRACE NAME CONTEXT FOREVER, LEVEL 12'||'''');End;

Note:ptian123为sql trace一个标示，可以自行定义

2.运行Concurrent Request

3.查找user_dump_dest

select name, value
from v$parameter
where name like 'user_dump_dest';

4.切换到user_dump_dest目录，并ls *ptian123*

Refer:

How To Create a User Event Trace by Using Profile Option: Initialization SQL Statement - Custom (Doc ID 170223.1)