open cursors
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: open cursors

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    In the init.ora of my database, max_open_cursors is set to 500.

    Is there a cost in memory or performance if I bump it to 2000?

    Idle sessions have open cursors that never close. This seems like an application problem that would be better solved by fixing the code rather than increasing the max number of open cursors.

    Any suggestions?

  2. #2
    Join Date
    Sep 2000
    Posts
    43
    I would agree. If you could change code rather than increasing open_cursors parameter I would do it. 500 is already large enough value.
    Alla S. Pfauntsch
    Oracle DBA
    ========================================
    "Life is what happens while you are planning something else".

  3. #3
    Join Date
    Oct 2000
    Posts
    57


    You can use dbms_session.set_close_cached_open_cursors to close the open cursors in oracle8i .

    Or you can kill those idle sessions and it will get removed from
    sqlarea.

    thanks

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