Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: elapsed times for current queries
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