DBA FUS‎ > ‎

Finding longops

posted Sep 13, 2010, 7:04 AM by Sachchida Ojha
select * from (
  select opname, target, sofar, totalwork,
         units, elapsed_seconds, message
  from v$session_longops order by start_time desc)
where rownum <=1;

On a busy server one would like to add filter on sid and serial# in the inner query to get the info only about the necessary session and the query is as follows:

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