Re: Duration of Transaction

Vincento Harris wrote:

> I will like to get the duration of a transaction
>
> Start_time from v$transaction tells when the transaction started.
>
> Need help performing the calculation of sysdate-start_time to give
> the duration of transaction.Hopefully the query will be on the
> V$transaction view not on session_longops whose results have not been
> very dependable(at least for me)
> Hp unix
> oracle 8.1.7.4
>
>
> Thanks in advance
>
> Vincento

Go to http://tahiti.oracle.com and look up DBMS_UTILITY.GET_TIME built-in package function.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)