SELECT a.value,
  s.username,
  s.sid,
  s.serial#
FROM v$sesstat a,
  v$statname b,
  v$session s
WHERE a.statistic# = b.statistic#
AND s.sid          =a.sid
AND b.name         = 'opened cursors current'

SELECT s.machine, oc.user_name, oc.sql_text, count(1)  cnt
FROM v$open_cursor oc, v$session s
WHERE oc.sid = s.sid
GROUP BY user_name, sql_text, machine
--HAVING COUNT(1) > 2
ORDER BY count(1) DESC

Select *  from v$parameter  where name like  'open_cursors';