Oracle Database Discussions

Hi

Please tells me what is the relation between Open Cursor & Sessions ?

I open one connection in toad and run

SELECT SUM (a.VALUE) total_cur, AVG (a.VALUE) avg_cur, MAX (a.VALUE) max_cur,
s.username, s.machine
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'
GROUP BY s.username, s.machine
ORDER BY 1 DESC

it is showing me

TOTAL_CUR AVG_CUR MAX_CUR USERNAME MACHINE
2 2 2 MANI MANI

In one connection how may cursor can be open? If i close the session does it close all the cursors?

Thanks in Advance

Mani