set feedback off
set linesize 130
set pagesize 90
set long 60
col user_name format a12 head 'User Name'
col osuser format a12
col sid format 999 head SID
col serial# head Ser# format 99999
col command head C format 99 truncate
col sql_text head "SQL_TEXT" format a60
break on report on user_name on s.sid on serial# on OSUSER
compute sum of Cursors on report
select o.user_name, osuser,s.sid, serial#, count(sql_text) Cursors
from v$open_cursor o, v$session s
where o.saddr = s.saddr
and username is not null
group by user_name, s.sid, serial#, osuser
/