Use below script to find the long running queries in your database.

select sid,inst_id,opname,totalwork,sofar,start_time,time_remaining 
from gv$session_longops 
where totalwork<>sofar
/

SEE – COMPLETE COLLECTION OF DATABASE SCRIPTS