set linesize 200;
set pages 80;
select count(*),
       cast(substr(machine,1,30) as char(30)) box,
       cast(substr(username,1,8) as char(8))username,
       cast(substr(osuser,1,20) as char(20)) os_user,
       cast(substr(program,1,30) as char(30)) program,
	   cast(substr(wait_class,1,20) as char(20)) wait_class,
	   status
from  v$session
where type='USER'
group by
       substr(machine,1,30),
       substr(username,1,8),
       substr(osuser,1,20),
       substr(program,1,30),
	   substr(wait_class,1,20),
	   status
--having count(*) > 1
order by count(*) desc;
select * from v$resource_limit where resource_name in ('processes','sessions');