DBMS_PROFILER详细解析及其步骤
原文英文,约900词,阅读约需4分钟。发表于: 。Detailed Explanation of START Profiling, EXECUTE PL/SQL Block, and STOP Profiling in DBMS Profiler The DBMS_PROFILER package provides utilities for profiling the execution of PL/SQL code....
DBMS_PROFILER包用于分析PL/SQL代码的执行性能。通过START_PROFILING开始分析,执行代码后收集数据,最后用STOP_PROFILING结束分析。数据存储在PROFILER_RUNS和PROFILER_LINES等表中,便于后续优化。