set lines 132
set pages 300
column numopencursors format d8
column machine format a30
column osuser format a20
column username format a20
SELECT s.sid, v.value as numopencursors ,s.machine ,s.osuser,s.username
FROM V$SESSTAT v, V$SESSION s
WHERE v.statistic# = 3 and v.sid = s.sid ;