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

Thread: Open Cursor Problem

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Posts
    188

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

    Regards
    Thomas Schmidt

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

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    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