Re: Initialize parameter

Depends on the parameter.
Some are modifiable on session level
some on system level
most by changing the init<sid>.ora only. Reference manuals should state which are modifiable, it is also contained in the v$parameter view in the columns is_sesmodifiable and is_sysmodifiable. Of course you will loose your changes if you don't change them in ini<sid>.ora and reboot the database.

If you change the init<sid>.ora and want your changes to become active you'll need to 'bounce' (shutdown and startup your database). Anyway, that's nothing new: Windoze needs to do that too usually.

Regards,

Sybrand Bakker, Oracle DBA

"Johnson" <syner_at_pd.jaring.my> wrote in message news:8pk1ci$ivr$1_at_news4.jaring.my...
> Hello DBA,
>
> In Oracle 7, Oracle 8, Oracle 8i, what is the correct procedure to change
> the Parameter Setting.
>
> Do I need to shutdown the Database, when ever I need to change/modify the
> Parameter setting.
>
> Regards.
>
>
>
Received on Tue Sep 12 2000 - 07:04:35 CEST