ora-01000
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ora-01000

  1. #1
    Join Date
    Feb 2001
    Posts
    114
    hi,

    what do i change in parameter settings if i get ora-01000
    maximum open cursors exceeded

    thanks


  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    In your inisid.ora file increase the number of OPEN_CURSORS = parameter to some reasonable value.

    You can find this file unser $ORACLE_BASE/admin/SID/pfile/


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Feb 2001
    Posts
    114
    thanks sambavan,

    i increased the OPEN_CURSORS=1000
    but what exactly does it mean, what does this increase do ?

    thanks

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Whenever you log in and issue a select statement, it would become a cursor. This is one of the tuning parameters should always be check. On the other hand, if there are going to be a number of people logging into your database and doing all kinds of query, the limit keeps going up. Here is one of the closely related thread on similar parameter setting. Check that out. The OPEN_CURSORS sets the max number of cursors that can be opened on your system at one point. When there are idle sessions, which had performed the querry operations and now have not been closed would contribute to that of holding the cursors count for no reason. So set some profile to the user sessions that would be closed if it were to be idle for a certain period of time. This would help in releasing the resources.

    Relevent thread:
    http://www.dbasupport.com/forums/sho...threadid=11524


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Feb 2001
    Posts
    114
    Thanks Sambavan,
    It was a nice explanation.

    thanks again

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