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 /