Results 1 to 2 of 2

Thread: max cursors

  1. #1
    Join Date
    Dec 2010

    max cursors

    im quite confused with the max cursor setting in "show parameters".

    for example i set it at 3000. does this mean that each connection will have 3000 or a shared by different connectioN?

    what if 2 applications uses the same user/pass, do they share with the 3000 or they have individual 3000 cursors?


  2. #2
    Join Date
    Jan 2011
    Hi, max_cursors specified are per session and not for the entire instance. so, each session/connection to the database will be granted a maximum of 3000 open cursors after which oracle will complain informing you that max cursors have been exceeded.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts