Open Cursors Parameter
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Open Cursors Parameter

  1. #1
    Join Date
    Nov 2001
    Posts
    118
    Hi Everyone,
    When the documentation recommends to set the open_cursors init.ora parameter as high as the operating system allows, how do I find out how high this value can be?
    (This is for a Solaris OS.)

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Hi

    I think it is better to understand your application and set the value accordingly instead of putting the maximum value. Estimate the maximum open cursors at time by a session and set it.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  3. #3
    Join Date
    Nov 2001
    Posts
    118
    I agree, but there's a problem: I'm migrating an application and the developers themselves don't even know how many cursors might be opened simultaneoiusly by their scripts (doh!).
    They only know there are a forrest full of users opening a bucketfull of cursors all over the place. Up until now this was on Informix (double-doh!), but Oracle needs more precise information.

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