Siebel SQLs/Error Messages >  Finding long running queries in Oracle

select s.SQL_HASH_VALUE, count(*)
from v$session s
where s.LAST_CALL_ET > 3000
and s.STATUS = 'ACTIVE'
group by s.SQL_HASH_VALUE
order by count(*) desc;

--the hash value from the query
--and then

select *
from v$session
where sql_hash_value = 'hashvaluenumber';

select t.SQL_TEXT
from v$sqltext t
where t.HASH_VALUE = 'hashvaluenumber'
order by t.PIECE;