Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Long - running queries
Margie wrote:
> Does anyone have a query to detect long-running queries? Thanks...
try:
select sid, serial#, opname, target, sofar, totalwork, units,
to_char(start_time,'DD/MON/YYYY HH24:MI:SS') Start_Time,
to_char(last_update_time,'DD/MON/YYYY HH24:MI:SS') last_update_time,
time_remaining, elapsed_seconds, message, username
from v$session_longops
where time_remaining != 0;
Received on Fri Jul 30 2004 - 13:03:19 CDT