Problems with open Cursor Please Help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Problems with open Cursor Please Help

  1. #1
    Join Date
    Mar 2001
    Posts
    188

    Question

    Hello there,
    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
    much ???
    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 !!!!

    Regards
    Thomas Schmidt

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    Hi.
    We had the same problem and solved it by switching to Oracle's latest jdbc drivers (8.1.7)

    Good Luck

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width