Number of Open Cursors?

From: Boss <h>
Date: Wed, 14 May 2003 22:45:28 +0200
Message-ID: <3ec2aad8$0$97243$edfadb0f@dread12.news.tele.dk>

I'm are facing a problem with max. number of open cursors exeeded

Querying the v$sesstat (statistic#=3) I can observe how many open cursors a session has. The returned number corresponds to the number of entries in v$open_cursor.

But according to Metalink note:1020427.102 the cursors remain in v$open_cursor even if they are closed by the application.

The question is: How does Oracle keep track on which cursors are actually open (=not closed) and which are kept for caching??

The v$sesstat (statistic#=3, opened cursors current) should show current number of opened cursors - but it seems as it shows how many distinct cursors that were opened for this session (until it reaches the maximum=OPEN_CURSORS). Of what use is this statistic then??

When does Oracle actually raise: ORA-1000 Maximum open cursors execeeded ???

Regards
Hans Peter Received on Wed May 14 2003 - 15:45:28 CDT