Using The Profiler API: Package DBMS_PROFILER【每日一译】--2013-1-22

After you have collected data with the Profiler, you can do the following:
■ Analyze the Collected Performance Data
Determine why more time was spent executing certain code segments or accessing
certain data structures. Find the problem areas by querying the performance data.
Focus on the subprograms and packages that use up the most execution time,
inspecting possible performance bottlenecks such as SQL statements, loops, and
recursive functions.
■ Use Trace Data to Improve Performance
Use the results of your analysis to rework slow algorithms. For example, due to an
exponential growth in data, you might need to replace a linear search with a
binary search. Also, look for inefficiencies caused by inappropriate data structures,

and, if necessary, replace those data structures

在你已经收集了数据使用仿制器，你可做如下事情：

#分析收集的性能数据

确定为什么很多时间花费在确定的代码段或者访问确定的数据结构。找到问题区域通

过查询性能数据。集中于子程序和包，这些耗费了最大执行时间的东西，检查可能的

性能瓶颈问题。比如SQL语句，LOOPS循环和递归函数。

#使用追踪数据去提高性能

使用分析的结果去重做慢的算法。比如，因为一个指数倍增长的数据，你可能需要通

过二进制查找来替换线性查找。同理，不适合的数据结构导致的没有效率的查找，如果

需要，更换掉那些数据结构。