PL/SQL的代码覆盖率

本文介绍了PL/SQL的代码覆盖率的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

任何人是否有工具或具有PL/SQL代码覆盖方面的经验.我相信可以使用DBMS_PROFILER吗?

Does anyone have tools or experience with code coverage for PL/SQL. I believe this is possible using DBMS_PROFILER?

推荐答案

www.toadworld/BLOGS/tabid/67/EntryID/267/Default.aspx 包含有关使用PL/SQL探查器检查代码覆盖率的信息.

www.toadworld/BLOGS/tabid/67/EntryID/267/Default.aspx has info about checking code coverage using the PL/SQL profiler.

Metalink文章243755.1实现和使用PL/SQL Profiler"中包含有关在9i或10g上进行概要分析的一些有用信息，以获取有关概要分析代码的信息.从文章底部获取prof.zip，它有一个profiler.sql，它将在分析运行后很好地格式化结果.

Some helpful info about profiling on 9i or 10g is included in Metalink Article 243755.1 "Implementing and Using the PL/SQL Profiler" for information on profiling code. Grab the prof.zip from the bottom of the article, it has a profiler.sql which will nicely format your results after a profiling run.

此处提供了没有MetaLinka帐户的更多10g文档: download.oracle/docs/cd/B19306_01/appdev.102/b14258/d_profil.htm

More 10g documentation is available here without a MetaLinka account: download.oracle/docs/cd/B19306_01/appdev.102/b14258/d_profil.htm

如果您正在运行11g，则此处记录了一个新的Hierarchical Profiler: download.oracle/docs/cd /B28359_01/appdev.111/b28424/adfns_profiler.htm

If you are running 11g there is a new Hierarchical Profiler documented here: download.oracle/docs/cd/B28359_01/appdev.111/b28424/adfns_profiler.htm