maximum # of cursors per user
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: maximum # of cursors per user

  1. #1
    Join Date
    Jun 2000
    Location
    dumfries,va,usa
    Posts
    227

    Red face

    Hi,
    Can someone please let me know what is the limit you can set OPEN_CURSORS on NT server. Also, what is the additional overhead invovled in setting this parameter to the maximum.

    Thanks,
    Leonard
    leonard905
    leonard905@yahoo.com

  2. #2
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    The default is usually around 50. It can be changed in the init.ora at least and maybe in the PRO*xxxxx. Overhead varies a little.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  3. #3
    Join Date
    Jun 2000
    Location
    dumfries,va,usa
    Posts
    227
    What I need to know is specific to nt. The limit you can set the open_cursors.

    Thanks,
    Leonard905
    leonard905
    leonard905@yahoo.com

  4. #4
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    I have set upto 200 in NT with no problems.
    Hemant

  5. #5
    Join Date
    Sep 2000
    Location
    Calcutta / Ahmedabad, India
    Posts
    137
    as far as i think there is no hard and fast rule to set the maximum limit of any of the init.ora parameters as long as you have sufficient resources to support your configuration, though the value of some init.ora parameters are set with respect to the value of other parameters.
    Suvashish

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you can set it high but does your application really opens so many cursors per session???

  7. #7
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Talking do this


    have your developers always "CLOSE cursor_name;"
    at the end of all their statements. Seems to me like they are leaving the cursor open in all of their functions.

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