To get SQL Trace
来源:互联网 发布:寻侠突破数据 编辑:程序博客网 时间:2024/05/16 12:56
To get SQL Trace
. Set profile FND: Diagnostics to Yes at user level.
. Login as the above user
. Click on Diagnostics icon(Home Page).
. Select 'Set Trace Level' and click Go
. Select the desired trace level (binds and waits) and click Save
. Run Depreciation
. Click Diagnostics icon
. Select 'Set Trace Level' and “No Trace”, click Go
. Take note of the Trace ID numbers on the left side of the page (Typically there will be multiple file numbers; these Trace ID number will be part of the raw trace file name)
. Find the trace files using command like below. See Note 290614.1 to find the location of the trace files which depends on the rdbms version.
$ ls -lt *<file number>*
. Login as the above user
. Click on Diagnostics icon(Home Page).
. Select 'Set Trace Level' and click Go
. Select the desired trace level (binds and waits) and click Save
. Run Depreciation
. Click Diagnostics icon
. Select 'Set Trace Level' and “No Trace”, click Go
. Take note of the Trace ID numbers on the left side of the page (Typically there will be multiple file numbers; these Trace ID number will be part of the raw trace file name)
. Find the trace files using command like below. See Note 290614.1 to find the location of the trace files which depends on the rdbms version.
$ ls -lt *<file number>*
--on database server
Execute tkprof in the trace files with sort options exeela, fchela, prsela as it sorts sql statements by execution, fetch and parse time. This will list them first, syntax is:
$ tkprof explain=apps/ <pwd> sort='(prsela,exeela,fchela)'
- OR -
$ tkprof <filename> output=/<path>/<filename.prf> explain=apps/<pwd> sort='(exeela, fchela,prsela)'
Execute tkprof in the trace files with sort options exeela, fchela, prsela as it sorts sql statements by execution, fetch and parse time. This will list them first, syntax is:
$ tkprof explain=apps/ <pwd> sort='(prsela,exeela,fchela)'
- OR -
$ tkprof <filename> output=/<path>/<filename.prf> explain=apps/<pwd> sort='(exeela, fchela,prsela)'
0 0
- To get SQL Trace
- How to get trace file from getbfno.sql gettrcname.sql
- how to make&get trace file
- Using netconsole to get remote trace message
- How to Generate SQL Trace In OAF
- How to get a stack trace on Windows zz
- how to get the function back trace in php
- How to get the full error stack trace of SharePoint
- How To Use TKPROF To Trace And Analyze Sql Explan
- Using Profile "Initialization SQL Statement - Custom" to collect sql trace
- SQL Trace
- SQL Trace
- SQL Trace
- How to read a SQL Trace in PeopleSoft
- How to Use Oradebug to Get Trace File Name and Location
- get trace name
- How to use SQL store procedure to trace SQL performance instead of SQL profiler
- Try: Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get m
- Android开发:NAND: could not write file ...Temp\\AndroidEmulator\TMP365.tmp异常处理
- Tomcat常用配置
- 技术学习
- textField 小结大全
- unity2d 修改sprite填充图片
- To get SQL Trace
- Linux ALSA声卡驱动之二:声卡的创建
- uva 11456 - Trainsorting(LIS)
- eclipse导入工程中文乱码问题
- PowerMock中replayAll,verifyAll,resetAll 方法的使用
- UML类图关系
- C# 开机启动程序
- html网页背景音乐代码
- 时间复杂度和空间复杂度