Cheeky Cockatoo

Life Advice and Stories, Travel, Oracle Tech, Good Food and More

long_ops.sql

Download Script

select sid, serial#, username, sofar, TOTALWORK, message
from v$session_longops where sofar < totalwork
and exists (select sid from v$session s where s.username = username
and status = 'ACTIVE')
order by 1
/