"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)

ITPub博客

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

最新文章