column osuser format a10
column username format a30
column machine format a30
column program format a40
column sid format 99999999
column serial# format 99999999
column TOT format 999999 heading “Total Sessions”
break on report
compute sum of TOT on report
set lines 141
set pages 500
select machine, osuser, username, count(1) “TOT” from v$session
group by machine, osuser, username
order by username;
!ps -ef | grep -v grep | grep WEBP18F |wc -l