How do you determine what sessions are connected and what resources they are using?
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Answer by Tariq Rahiman · Nov 09, 2009 at 04:22 PM
SELECT USER#, CASE WHEN USERNAME IS NULL THEN 'BACKGROUND' ELSE USERNAME END AS USERNAME, STATUS,TYPE, PROGRAM,MACHINE,OSUSER,SERVER,SID FROM V$SESSION ORDER BY USERNAME
Answers Answers and Comments
No one has followed this question yet.
How can I list all sessions currently connected to a specific database using dynamic management views.
Can the sql scheduler yield in the middle of a session?
Best SQL Server Blogs
Multiple sessions of Specific Database needs to be Killed