DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2001


    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 !!!!

    Thomas Schmidt

  2. #2
    Join Date
    Nov 2000
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.