PL/SQL Profiling

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======