Oracle Session Related quires :

Select   'long', to_char (l.sid), to_char (l.serial#), to_char(l.sofar), to_char(l.totalwork), to_char(l.start_time, 'DD-Mon-YYYY HH24:MI:SS' ),  
to_char ( l.last_update_time , 'DD-Mon-YYYY HH24:MI:SS'), to_char(l.time_remaining), to_char(l.elapsed_seconds),                              
l.opname,l.target,l.target_desc,l.message,s.username,s.osuser,s.lockwait from  v$session_longops l, v$session  s
where l.sid     =  s.sid and l.serial# =  s.serial#;
 

Select   'long', to_char (l.sid), to_char (l.serial#), to_char(l.sofar), to_char(l.totalwork), to_char(l.start_time, 'DD-Mon-YYYY HH24:MI:SS' ),  
to_char ( l.last_update_time , 'DD-Mon-YYYY HH24:MI:SS'), s.username,s.osuser,s.lockwait from  v$session_longops l, v$session  s
where l.sid     =  s.sid and l.serial# =  s.serial#;

select substr(username,1,15),target,to_char(start_time, 'DD-Mon-YYYY HH24:MI:SS' ), SOFAR,substr(MESSAGE,1,70) from v$session_longops;

select USERNAME, to_char(start_time, 'DD-Mon-YYYY HH24:MI:SS' ),substr(message,1,90),to_char(time_remaining) from v$session_longops;