How to find long running queries with Oracle
select elapsed_time/1000000 seconds, gv$sql.* from gv$sql order by elapsed_time desc;
If you need to check the content of the placeholders (:paramX) then try this query :
select * from v$sql_bind_capture bc where bc.sql_id = 'SQL ID' and bc.child_number = XXXX
Source : Stackoverflow but lost the direct link.