hi,
maximum open cursors depend on your operating system but is usually more
than the default. to increase the open cursors:
in your parameter file (init<sid>.ora) add;
open_cursors = 255
save the file.
shutdown the database
restart the database
to check if the parameter has taken effect use the view
sys.v$parameter.
Vijay
In article <82gmfu$gr5$1_at_nnrp1.deja.com>,
elizabeth1000_at_my-deja.com wrote:
>
>
> I need to bump up my open cursors parameter on a database it is
> currently at the default of 50. When I put the new value into the init
> file if I then stop and start the database will that cause the new
> value to take effect?
>
> Thanks
>
> E
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Dec 06 1999 - 11:18:13 CST
