Query Oracle long running operations

OraLongOps

select  * from v$session_longops
where last_update_time > trunc(sysdate)
order by start_time desc;


select trunc(start_time), count(*)
from v$session_longops
group by trunc(start_time)
order by trunc(start_time);