ORA-01000: maximum open cursors exceeded
Posted on 2007-10-15
Hi, I got this when I simulated 100 concurrent user access (each user access will take more than 1 connection): ORA-01000: maximum open cursors exceeded. I think I can change the max open cursor's value to 500 through the config file (.ora). How do I check whether it had been changed correctly? Any command that I can execute? Besides this and processes variables, is there any other variable that will limit the number of connection? Please advise, thanks.