Message-Id: <10714.124891@fatcity.com> From: Muru Bala Date: Mon, 18 Dec 2000 19:37:50 -0800 (PST) Subject: How Oracle processes close cursor/cursor variable which were not closed programmatically? 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.