Home » SQL & PL/SQL » SQL & PL/SQL » open cursor problem
open cursor problem [message #36315] Fri, 16 November 2001 00:48 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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

----------------------------------------------------------------------
Previous Topic: how do i print the no of records affected after my insert/update/delete statements in my procedure
Next Topic: possibility to list files in a directory ?
Goto Forum:
  


Current Time: Sun May 31 18:02:00 CDT 2020