SQL Timer, Performer

[orozcom]

I need to find a free tool, or develop and application that will take an Collection of String SQL Statements from an Oracle DB. Process each statement one at a time and time each statement from start to return. Anyone know of anything?

 

[sedj]

String[] statements = ...
Connection conn = ...
for (int i = 0; i < statements.length; i++) {
  // should use Callable or Prepared Statements if you can
 Statement s = conn.createStatement();
 ResultSet rs = s.executeQuery(statements[i]);
 while (rs.next()) {
   // do stuff with ResultSet
 }
}