Tagged Questions
1
vote
3answers
45 views
Live monitoring SQL statements on SQL Server
How can i monitor running SQL Statements for my SQL-Server, is it possible using only SQL Server without 3rd part tools?
As an alternative can anybody recommend any free tool which can monitor ...
1
vote
1answer
449 views
How do you monitor specific SQL statement of a specific user ?
We have a few standalone users here which cause high server loads for several 11.1.0.7 Oracle's.
I spoke with them a few times but it seems that their queries are causing high loads and probably ...
1
vote
1answer
680 views
Oracle Script For Getting Long Active Sessions
Is there any script that you could provide for v$session? I seem to be encountering an issue in which my oracle active sessions are filled up. This is when I do
SELECT * FROM V$SESSION WHERE STATUS = ...
13
votes
3answers
9k views
How to find the latest SQL statements within the database?
I like to get the latest executed statements within my database, along with performance indicators.
As such, I like to know, which SQL statements were most CPU/DISK intensive.
