Open cursors and more open cursors

When I select select sid, count(*) from v$open_cursor group by sid; I find some sessions have 250 open cursors. I am 99% confident that there are not 250 cursors open but why is this view reporting so many. (in fact some are duplicates same address and hash value 2,3,4,5 times)

I believe the developers are using implicit cursors in some situations but shouldn't they be closed after the procedure ends. If not is there anyway to close the implicit cursor explicitly? Lastly how can I tell how much memory is being wasted by having all these opened cursors.

Thanks,
scott. Received on Mon Nov 08 1999 - 22:35:54 CST