Cheeky Cockatoo

Life Advice and Stories, Travel, Oracle Tech, Good Food and More

num_users.sql

Download Script

col machine format a22
col program format a40
col nu      format 9999
select count(*) nu, machine, program
from v$session
group by machine, program
order by 1
/