DBA FUS‎ > ‎

SQL to show longops

posted Sep 11, 2010, 5:24 AM by Sachchida Ojha   [ updated Sep 11, 2010, 5:25 AM ]
select * from (select opname, target, sofar, totalwork,units, elapsed_seconds, message from v$session_longops order by start_time desc)
where rownum <=1;

select * from (select opname, target, sofar, totalwork,units, elapsed_seconds, message from v$session_longops
where sid = <sid> and serial# = <serialno> order by start_time desc)where rownum <=1;
Comments