I'm trying to figure out a way to find queries running longer than X minutes in the data dictionary. It's been difficult to limit it to a specific query. Sessions are no problem. Here's the latest query I've come up with.
FROM v$sql s,
WHERE s.address = sess.sql_address
AND sess.status = 'ACTIVE'
AND ops.sid = sess.sid
AND sess.username not like 'SYS%'
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!