rem *************************************************************

rem * Name : OPENCURSOR.SQL

rem *

rem * Date: July 15 2001

rem * Purpose: Show open cursors per user/process

rem *

rem * Downloaded from www.oradev.com

rem *************************************************************





select substr(ses.username||' '||ses.osuser,1,30) user_osuser

,      stat.value open_cursor

,      ses.process process

from   v$sesstat stat

,      v$session ses

where stat.statistic# = 3

and   stat.sid = ses.sid

;