How Oracle processes close cursor/cursor variable which were not closed programmatically?

From: Muru Bala <murubala321_at_yahoo.com>
Date: Mon, 18 Dec 2000 19:37:50 -0800 (PST)
Message-Id: <10714.124891@fatcity.com>

Hello Lists,

I am using REF CURSOR for running a query and retrieving data. The REF CURSOR is coded inside a PL/SQL procedure which is called by a C++ application through Oracle ODBC. The C++ application is using a open() method to call this stored procedure and assign the result to a RecordSet object.

We running into ORA-01000 maximum number of open cursors reached error. I increased open_cursors from 50 to 500. Still after about 35000 number of procedure calls, we are getting this error.

My question is: Somehow, the C++ applicaion is not closing the opened REF CURSOR after its use. How does Oracle SMON or PMON close these opened cursors periodically? How frequent the closing is done? Is there a way to check this using dictionary tables? Is it possible to increase the frequency of closing?

I feel I am going wrong somewhere, I would like to get this clarified from you. Any level of help would be highly appreciated.

TIA,
Muru

---

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products. Received on Mon Dec 18 2000 - 21:37:50 CST