Select

l.SID,

l.START_TIME,l.TIME_REMAINING,l.MESSAGE,l.LAST_UPDATE_TIME

From v$session_longops l         

Order By l.LAST_UPDATE_TIME Desc;