find_open_cur.sql Find open cursorts per session

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 ;