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.

Published 3rd Mar 2014 // #oracle

comments powered by Disqus