/* title: “How to find long running queries with Oracle " date: 2014-03-03 tags: [oracle ] */

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.