Whats Running?
Whats Running?
SELECT s.sid, s.serial#, s.username, s.osuser, s.machine, s.program,
q.sql_text
FROM v$session s
JOIN v$sql q ON s.sql_id = q.sql_id
WHERE s.type = 'USER'
AND s.status = 'ACTIVE';
SELECT sid, serial#, context, sofar, totalwork,
ROUND((sofar/totalwork)*100,2) "%_COMPLETE"
FROM v$session_longops
WHERE opname LIKE 'REFRESH MATERIALIZED VIEW%'
AND totalwork != sofar;