Couldn't find the long running SQL under v$session_longops
The best view (for me) to see the status of a long query is V$SQL_MONITOR.
This view include all query that has consumed at least 5 seconds of CPU or I/O time.
This view is very volatile, so you have to answer it faster after it's execution.
If you can't find it into this view, you can find it in a awr report