title: Meaning of Elap per Exec (s) on Oracle AWR Reports
body: <p>In SQL ordered by Elapsed Time / Elap per Exec (s)  ---it is the time the result of the sql reach the client ? </p>
  
  <p>I read this document How to Identify Resource Intensive SQL where </p>
  
  <p>where it is defined Response Time = Service Time + Wait Time</p>
  
  <p>Is the response time = elapsed time (s) ?  or is only part of the Service Time</p>
  
  <p>Thanks</p>
  
  <hr>
  
  <p>Just got this from an Oracle Forum:</p>
  
  <p>(1) Elapsed Time = "CPU Time" + "Non-Idle Wait Time" + "Elapsed Time Unaccounted-for".</p>
  
  <p>(2) Response Time Accounted-for = "Elapsed Time" + "Idle Wait Time".</p>
  
  <p>(3) Total Response Time = "Response Time Accounted-for" + "Response Time Unaccounted-for".</p>