PL/SQL的代码覆盖率 [英] Code coverage for 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?

推荐答案

http://www.toadworld.com/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文档: http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_profil.htm

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

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

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

这篇关于PL/SQL的代码覆盖率的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！