Look at dba_blockers and dba_waiters. You can then look at v$sqlarea to find the sql being run via sql_id. v$session_longops might also be useful.