I want to know who is slowing the database.
Someone is running the query from hell.
I know wich query, but i dont know who is running it.
Could someone give me a query to find top bad sql statement and to fing who is running it?

I have statspack and some query i use to find bad sql statement.

select a.disk_reads,a.buffer_gets, B.SQL_TEXT
from v$sqlarea a,v$sqltext B
where A.disk_reads > 10000
AND A.ADDRESS = B.ADDRESS
order by A.disk_reads desc, b.piece;

This give me top sql statement to tune. But i dont know who.

I want to tell that user to stop, cuse hes slowing the entire database.