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%'
October 8, 2004 10:53 AM
October 18, 2004 10:20 AM