SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Code coverage tool

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
Code coverage tool
Author Message
Jane



Joined: 06 Dec 2002
Posts: 4

Post Code coverage tool Reply with quote

Hi,

I'm looking into a tool to reveal PL/SQL code coverage. Any suggestions?

Thanks,
Jane

Tue Mar 14, 2006 4:34 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7970

Post Re: Code coverage tool Reply with quote

What is "PL/SQL code coverage?"

: Hi,

: I'm looking into a tool to reveal PL/SQL code coverage. Any suggestions?

: Thanks,
: Jane

Tue Mar 14, 2006 9:01 pm View user's profile Send private message
Neil jennings



Joined: 26 Apr 2006
Posts: 1

Post Re: Code coverage tool Reply with quote

: What is "PL/SQL code coverage?"
I am looking for a similar tool.

Basically, it should tell, for any specific test run or for a series of tests, what percentage of the code has been executed.
This is obviously a measure of how much of the program has been tested. Entry criteria to System test often require evidence that at least, say, 90% of the code has been executed in Unit (module, procedure) testing.

It is not always possible to execute 100%, though that is the aim.

Even 100% cannot PROVE that the code is correct (You cannot ever prove a program is correct by testing), but it is more likely than if the coverage is only 10%


Wed Apr 26, 2006 3:33 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7970

Post Re: Code coverage tool Reply with quote

DB Audit is a tool that can be used for that purpose. It will tell you which units have been executed or accessed, when and by whom. DB Audit can be setup to capture every SQL command executed in the database or it can be configured to capture only specific commands or access to specific objects only.

If you want to profile the entire database, using DB Audit enable auditing for all SQL commands, let it run for a while. Then create a report that calculates summaries by procedure, function, table, ets....

: I am looking for a similar tool.

: Basically, it should tell, for any specific test run or for a series of
: tests, what percentage of the code has been executed.
: This is obviously a measure of how much of the program has been tested. Entry
: criteria to System test often require evidence that at least, say, 90% of
: the code has been executed in Unit (module, procedure) testing.

: It is not always possible to execute 100%, though that is the aim.

: Even 100% cannot PROVE that the code is correct (You cannot ever prove a
: program is correct by testing), but it is more likely than if the coverage
: is only 10%

Wed Apr 26, 2006 9:03 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.