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;
Tags: 
Category: