Re: Initialize parameter

hi,

well there are static initialization parameters and there are dynamic ones. for static parameters you have to bounce (shutdown and restart) your instnce. for dynamic parameters there are further two catagories: session modifialbe and system modifiable. for both these types you could use 'alter session' and 'alter system' command to change there current value. setting in this case would take effect immediately without having to bound the instance. of course you'd like to make corresponding changes in the init<sid>.ora file so that every time your database goes up the new values are set automatically.

please refer to oracle online help, goto to oracle reference and there you'd find description of each init param, its type, range of values and wheather or not its static.

hope this helps.

ATTA In article <8pk1ci$ivr$1_at_news4.jaring.my>,   "Johnson" <syner_at_pd.jaring.my> wrote:
> 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.
>
>

--

getting the meanin' of data...


Sent via Deja.com http://www.deja.com/
Before you buy.