Using Profile "Initialization SQL Statement - Custom" to collect sql trace
来源:互联网 发布:汉仪菱心体简下载 mac 编辑:程序博客网 时间:2024/05/20 03:38
"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)
- Using Profile "Initialization SQL Statement - Custom" to collect sql trace
- sql trace profile笔记
- To get SQL Trace
- Using Oracle Trace Analyzer (trcanlzr.sql)
- Retrieving Data Using the SQL SELECT Statement
- LINQ to SQL系列Part 9-Using a Custom LINQ Expression with the control
- HOW TO ORDER BY A CUSTOM SQL FORMULA/EXPRESSION WHEN USING HIBERNATE CRITERIA API
- 使用java连接Mysql 和Using JDBC Statement Objects to Execute SQL
- SQL Trace
- SQL Trace
- SQL Trace
- How to Generate SQL Trace In OAF
- sql statement
- Script to Collect RAC Diagnostic Information (racdiag.sql)
- Finding SQL Server Deadlocks Using Trace Flag 1222
- How to get trace file from getbfno.sql gettrcname.sql
- [MSSQL]SQL Server 2008 Using the MERGE statement
- sql profile
- Baby Seat
- 程序员DIY真实版小机器人瓦力 人群之中寻找伊娃
- 关于Raid0访问性能的一点探讨
- 七夕在相爱人的眼中也是普通的一天 。
- 清除浮动解决方案
- Using Profile "Initialization SQL Statement - Custom" to collect sql trace
- delphi 读取 .dat文件数据
- ZOJ 1610
- JavaScript自学ing(1)
- ServletContext与ServletConfig的深度分析
- 实例给出Excel级联菜单(多个下拉选项)的实现
- java.sql.Date和 java.util.Date的区别及转换
- JMF教程
- 自动实现分页---分页标签"pg"使用