Problems with open cursor
I have a problem with an Application and the reason lays on the open cursor.
How much open cursor must declared in the init.ora. Are 1000 open cursor to
How eliminate i this problem with to much open cursor. If checked may
Application and i have all cursor always closed. But in the v$open_cursor i saw that there are over 400 and in the reality they are about 1000 open Cursor.
I now that they can come from java or from oracle direct, too, but can i close this open cursor on any way.
I'm so sorry about my bad english, i hope you understand me.
Thanks for the help !!!!
[Edited by tomate on 03-28-2001 at 01:26 AM]
THere is no problem with setting a higher value for open_cursors in the init.ora.
Click Here to Expand Forum to Full Width