| open cursor problem [message #36315] |
Fri, 16 November 2001 00:48  |
rahul khandelwal
Messages: 4
Registered: November 2001
|
Junior Member |
|
|
sir,
i am constantly getting the problem of maximum open
cursors.
i 'm using oracle 7.3 and the server is unix one.
in my initSID.ora file i cannot find the OPEN_CURSOR
parameter.but thru V$parameter i have come to know
that my open_cursor parameter has value 50 only.
please help me out in this matter and tell me where i
can find that parameter and in which file.
regards
rahul
----------------------------------------------------------------------
|
|
|
|
| Re: open cursor problem [message #36317 is a reply to message #36315] |
Fri, 16 November 2001 01:30  |
ssarzano
Messages: 2
Registered: November 2001
|
Junior Member |
|
|
You should put the parameter: OPEN_CURSOR=number in your initsid.ora file. After that you must restart your db.
Best regards,
Simone
----------------------------------------------------------------------
|
|
|
|
| Re: open cursor problem [message #36322 is a reply to message #36315] |
Fri, 16 November 2001 05:33 |
Rajarshi
Messages: 11
Registered: November 2001
|
Junior Member |
|
|
You must have opened a cursor loop continuously with in another loop without
explicitly closing it. Please explicitly close a cursor before opening
another, if they are not related.
This will surely solve your problem. Changing in initSID.ora might not help U a lot.
Thanks,
Rajarshi
----------------------------------------------------------------------
|
|
|
|
| Re: open cursor problem [message #36325 is a reply to message #36315] |
Fri, 16 November 2001 07:01 |
Somu
Messages: 24
Registered: February 2000
|
Junior Member |
|
|
Hi,
Add the following line into init<SID>.ora file and shutdown and startup the database.
open_cursors = 300
Actually , the number of cursor will vary depends on the database size, the minimum of 300 for the small database and you can increase it if you want it based on the database and the SGA memory size.
Regards
Somu
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
