Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: elapsed times for current queries

Re: elapsed times for current queries

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Mon, 2 Feb 2004 21:59:11 GMT
Message-ID: <401EC82F.E661DFA6@remove_spam.peasland.com>


If the query has been running for quite a while, then V$SESSION_LONGOPS will show you the elapsed time along with the estimated time remaining.

HTH,
Brian

Richard Kuhler wrote:
>
> Is there a way to get the elapsed times for all currently running
> queries? V$SQL.ELAPSED_TIME won't work because it's only updated when a
> query finishes. V$SESSION.LAST_CALL_ET won't work because it's only
> reset at the start of a PL/SQL call (not for each statement).
>
> Any ideas?
>
> --
> Richard Kuhler

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"
Received on Mon Feb 02 2004 - 15:59:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US