List open/active sessions

This lists open/active sessions.

By username:

select username
,      count(status) as Sessions
from v$session 
where username is not null --and status = 'ACTIVE' 
group by username
order by Sessions desc;

By os user

select osuser
,      count(status) as Sessions
from v$session 
where username is not null --and status = 'ACTIVE' 
group by osuser
order by Sessions desc;

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.