DBA Hub

📋Steps in this guide1/1

Find long running operations

select sid,inst_id,opname,totalwork,sofar,start_time,time_remaining from gv$session_longops where totalwork<>sofar /

oracle configurationintermediate
by OracleDba
15 views
1

Find long running operations

Code/Command (click line numbers to comment):

1
2
3
4
select sid,inst_id,opname,totalwork,sofar,start_time,time_remaining
from gv$session_longops
where totalwork<>sofar
/

Comments (0)

Please to add comments

No comments yet. Be the first to comment!