RE: SQL QUERY TIME

HI...

I think, you should query the V$TRANSACTION table to get the details about the transcations.

The start_time column gives the date and time, to which the transaction started.

Hope that this would help you.

Regards,
Nirmal.

> -----Original Message-----
> From: Wayne S Bellefeuille [SMTP:wbellefe_at_allina.com]
> Sent: Saturday, January 20, 2001 1:31 AM
> To: Multiple recipients of list ORACLE-L
> Subject: SQL QUERY TIME
>
> Is there any way to find out when a currently active query actually
> started
> running? I know Logon_Time on V$SESSION tells me how long they are
> connected,
> but I don't want that. And I know that First_Load_Time on V$SQLAREA
> points me
> toward the first time that a particular SQL_TEXT was executed by ANY user
> since
> DB startup, but I don't want that either.
>
> Any help would surely be appreciated.
>
> Wayne Bellefeuille
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Wayne S Bellefeuill
> INET: wbellefe_at_allina.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Sat Jan 20 2001 - 03:58:21 CST