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%
|