Oracle EBS下如何使用PL/SQL Profiling
1. Help -> Diagnostics -> Trace ->选上PL/SQL Profiling的check box
2. Perform your transaction
3. Uncheck ‘PL/SQL Profiling’
4. Logout EBS. 系统会弹出一个Message告诉你 “Concurrent request xxxx submitted to create the PL/SQL profiling report.”
5. 重新登入系统,在request里查询'PL/SQLProfiler Report' request。
什么情况需要收集PL/SQL Profiling output
首先你遇到的问题是性能问题,然后你已经收集了TKPROF,从TKPROF里看到消耗时间最长的sql是Procedure/Function,并不是一段普通的sql语句(select,update...),这个时候TKPROF已经帮不到什么了,因为我们并不知道,到底是procedure中的那段代码执行时间过长。这个时候我就需要PL/SQL Profiling来帮助我们分析到底是那段代码引起的性能问题。
using the PL/SQL Profiler, a line-by-line of the executed PL/SQL application code is reported, including the total execution time for each line of code,and how many times each of these lines was executed.
The actual PL/SQL Profiler is provided with the core RDBMS code, and it is well documented on the Supplied PL/SQL Packages and Types Reference manual, under the package nameDBMS_PROFILER.
PL/SQL Profiling output
output是一个DBMS_PROFILER产生HTML的页面,Sample:
Reference Note:243755.1 - Implementing and Using the PL/SQL Profiler
转载请注明出处:http://blog.csdn.net/pan_tian/article/details/7690784
======EOF======