Re: Newbie Question Changes to init.ora

From: <sbenitez_at_my-deja.com>
Date: Mon, 06 Dec 1999 18:39:20 GMT
Message-ID: <82gvs8$oek$1@nnrp1.deja.com>

Also, for future reference, if you type:

SELECT name, issess_modifiable, issys_modifiable FROM v$parameter;

From here it will tell you if these init.ora paramters can be modified either through a alter system or alter session, depending on which is TRUE. If both are false, you will need to bounce your instance after making the changes in init.ora for them to take effect.

Scott

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 - 12:39:20 CST