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; |
DBA FUS >