-
whos running what
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|