hi ,

Execute this script which will give the output u required.


REM
REM =====================================================================
REM
REM AUD043
REM
REM Opened Cursors by session
REM
REM Vinod Kumar M.G.
REM
REM =====================================================================
START envi

START titredba "Aud043" -
"Number of opened cursors by session"

COL sid FOR 999 HEAD "SID" TRUNC
COL user_ FOR A29 HEAD "OS USER" TRUNC
COL username FOR A30 HEAD "ORA USER" TRUNC
COL name FOR A39 HEAD "STATISTICS" TRUNC
COL value FOR 99999990 HEAD "OPENED|CURSORS" TRUNC

break on report
compute sum of value on report

SPOOL aud043

SELECT v.sid ,
v.username ,
p.username user_,
s.value
FROM v$sesstat s,
v$session v,
v$process p
WHERE s.sid = v.sid
AND 3 = s.statistic#
AND p.addr = v.paddr
ORDER BY
1
/
SPOOL OFF


Cheers,
Vinod