Is there any way, we can get list of all active sesions?
BI DWH BALA
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 Andrew Mobbs · Dec 03, 2009 at 02:10 PM
SELECT * from v$session
Answers Answers and Comments
No one has followed this question yet.
How do you determine what sessions are connected and what resources they are using
how to determine the session associated with a transaction that is blocking the tempdb
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?
Multiple sessions of Specific Database needs to be Killed