세션확인

select s.sid
     , s.program
     , ss.value "open_cursor"
  from v$sesstat ss, v$session s
 where ss.statistic# = 3
   and s.sid = ss.sid
 order by 3 desc


 select name, value from v$parameter where name = 'open_cursors'