/* Runstats Runstats is a tool to compare two different methods of doing the same thing and show which one is superior. You supply the two different methods and Runstats does the rest. Runstats simply measures three key things: • Wall clock or elapsed time: This is useful to know, but not the most important piece of information. • System statistics: This shows, side by side, how many times each approach did something (such as a parse call, for example) and the difference between the two. • Latching: This is the key output of this report. */ --In order to use Runstats, you need to set up access to several V$ views, create a table to hold the statistics, and --create the Runstats package. You will need access to four V$ tables (those magic, dynamic performance tables): --V$STATNAME, V$MYSTAT, V$TIMER and V$LATCH. Here is a view I use: create or replace view stats as select 'STAT...' || a.name name, b.value from v$statname a, v$mystat b where a.statistic# = b.st...