title: Oracle total query executions with count and execution time (for Java program)
body: <p>I want to know total how many queries got executed with its count and execution time for my Java program (I dont have the source code).</p>
  
  <p>I am planning to write PL/SQL which joins <code>gv$session</code> and <code>gv$sql</code>, logging output to one of the table. After program execution ends I will query the table to get more details.</p>
  
  <p>But I wanted to know whether Oracle has any default utility to get similar report already?  I was looking at AWR reporting for Oracle but didn't get easy documentation for the same.</p>