| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> elapsed times for current queries
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 KuhlerReceived on Mon Feb 02 2004 - 14:01:20 CST
![]() |
![]() |