| Size of OPEN_CURSORS in INITSID.ORA [message #72253] |
Thu, 24 April 2003 01:44  |
Peace
Messages: 1
Registered: April 2003
|
Junior Member |
|
|
How large of OPEN_CURSORS in INITSID.ORA can be ?
I found error: ORA-01000 maximum open cursors exceeded. so I want to increase size of this parameter.
But what size should be, can be musch as 1000, 2000, .. ?
|
|
|
|
| Re: Size of OPEN_CURSORS in INITSID.ORA [message #72254 is a reply to message #72253] |
Thu, 24 April 2003 02:50  |
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
|
Senior Member |
|
|
Hi,
we've about 50000 in one of our instances.
The question is how many cursors will be open during the operations you have on your DB. Mostly the Applications will not close the cursors properly. You can check how many open cursors are open from which user. This was one method to show our application company that their program did not close the cursors in our DB, onlyin their application.
regards
Uwe
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
