DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Hybrid View

  1. #1
    Join Date
    Mar 2001

    Question Problems with open cursor

    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

    [Edited by tomate on 03-28-2001 at 01:26 AM]

  2. #2
    Join Date
    Apr 2000
    Edison, NJ
    THere is no problem with setting a higher value for open_cursors in the init.ora.

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.