Again, a query for retrieving the number of open cursors per SID for the copy/paste-minded dba’s out there:
SELECT COUNT(CUR.SID) AS "NUM_OPEN_CURSORS"
, CUR.USER_NAME
, SES.OSUSER
, SES.MACHINE
FROM V$OPEN_CURSOR CUR,
V$SESSION SES
WHERE CUR.SID = SES.SID
AND CUR.USER_NAME NOT IN ('SYS', 'SYSTEM', 'OUTLN', 'AQ_ADMINISTRATOR_ROLE',
'DBA', 'EXP_FULL_DATABASE', 'IMP_FULL_DATABASE',
'OEM_MONITOR', 'CTXSYS', 'DBSNMP', 'IFSSYS',
'IFSSYS$CM', 'MDSYS', 'ORDPLUGINS', 'ORDSYS',
'TIMESERIES_DBA')
GROUP BY CUR.USER_NAME
,SES.OSUSER
,SES.MACHINE
/