Time elapsed Calculation I need to calculated time elapsed for each user to perform his part in a transaction.

The sequence is: 0 -1 - B2 or 0-B3
The table looks like the following:

+--------+--------+-------------------+------------------+-----------+
| id     | Trtype |Internal Status    | Timestamp        | User Name |
+--------+--------+-------------------+------------------+-----------+
|2072499 | BSE100 | 0                 | 03/06/2014 13:33 | User1     |
|2072499 | BSE100 | 1                 | 04/06/2014 08:53 | User2     |
|2072499 | BSE100 |B2                 | 03/06/2014 13:33 | User3     |
|2072605 | BSE100 | 0                 | 03/06/2014 13:33 | User1     |
|2072605 | BSE100 |B3                 | 03/06/2014 13:33 | User3     |
.....................


I am using the following sql query to generate the table above:

select h.id, h.trtype, T.DESCRIPTION, hist.internal_status,
 ts.description status_Desc, h.val_dte, h.account_dte, 
 hist.signature_timestamp, usr.login_name as user_name
  from k$transaction_header h, k$transtypes t, k$transaction_history hist, k$usr usr, K$TRANSACTION_STATUS ts
 where h.trtype = t.trtype
 and hist.trans_id = h.id
 and usr.id=hist.signature_usr
 and ts.id=hist.internal_status
 AND H.ACCOUNT_DTE = TO_DATE(&amp;DATE_YYYYMMDD, 'yyyymmdd')
 order by h.id, hist.internal_status
Do you want to calculate it by hand, or is it enough to let the oracle db to do the calculation?


  Question:  I want to see the response time for my SQL statement and see the run time.  What tools does Oracle provide to see how long a query runs?
  
  Answer:  For seeing the elapsed time for an individual query, you can see individual query response time in SQL*Plus with the “set timing on” command.
  
  SQL> set timing on;
  SQL> select stuff from mytab;
  
  Elapsed: 00:00:02.82


(directly from http://www.dba-oracle.com/t_measure_sql_response_time.htm) may be of some interest in that case.