Re: Unclosed cursors

Gints Tervits wrote:
>
> Can you tell something about following cursors problem. After executing
> of my database procedure, the statement "SELECT name, value FROM v$sysstat
> WHERE name = 'opened cursors current';" shows number of all cursors opened
> in this procedure. The statement "SELECT * FROM v$open_cursor;" still
> shows only one of them. The second launching of this procedure adds another
> equal number of opened cursors if observe with v$sysstat. So this leads to
> maximum open cursors exceeded error. The cursors are opened by dbml_sql
> package yet I have not forgotten to close them certainly. What could be the
> problem?
>
> Gints

Hello Gints !

I also had the same problem running Oracle Forms 4.0 on SCO Unix Openserver 5.0. The problem was that the cursors opened implicitely by Oracle Forms were never closed and the open_cursors defined in init.ora (default = 50) was reached.
Oracle Support in France does not consider it as bug (!) but could not provide me a workaround.
What I then tried is to put those lines in init.ora :

open_cursors = 150
close_cached_open_cursors = TRUE

Then, using sqldba or server manager, I could see the number of cursors decrease sometimes in v$sysstat. However, I don't know if I still can reach the fatal limit of 150 cursors !!!

Does anybody have any idea on the question ? The only solution I could provide is to logout from the Forms application and login again, which is quite difficult to explain to a customer !

Thanks a lot in advance,

Mathieu Hornsperger
Northern Telecom
Marne-La-Vallee, France
mlvmxh02_at_nt.com Received on Thu Jul 18 1996 - 00:00:00 CEST