open_cursor problems

Hello,
I have an issue with open_cursors and have read as much Metalink documentation that I can handle and am looking for a way to tell which cursors are still open, and if that is even possible. I have created two scripts from the Metalink information that tell me conflicting information:

select user_name, count(*) num
from v$open_cursor
group by user_name;

and the other is

select sum(a.value) as Count, b.name, c.user_name from v$sesstat a, v$statname b, v$open_cursor c where a.statistic#=b.statistic# and
a.sid = c.sid and
name = 'opened cursors current'
group by c.user_name, b.name;

but neither of these shows me that we are over the cursor limit. I have the value set to 200 and the most I ever get is about 160. My developers are starting to hate the fact that I cannot answer their question about when Oracle releases the cursor. Any specific scripts that you have that might give me the information would be appreciated and any advice other than increase OPEN_CURSOR would be great.

Eric Kimble Received on Fri Dec 22 2000 - 12:35:17 CST