Re: What init. parameters cannot be changed.

Jerry Gitomer wrote:
>
> laulau823_at_my-deja.com wrote:
> >
> > Could anyone tell me what init. parameters cannot be changed after
> > the database has been created? I only know that db_block_size cannot be
> > changed.
> > Moreover, I found that some init. parameters begin with an
> > underscore "_" character. What is the difference between these paramters
> > and other parameters not begin with an "_" character?
> > Thanks,
> > Alan
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
> I was told that the ones beginning with underscores should not
> be changed unless you are to do so by Oracle support. I think
> this means that if you mess around with them dire things can
> happen to your database.
> --
> Jerry Gitomer
> Once I learned how to spell DBA, I became one

The important difference is:

underscore parm - if you change it and things go wrong - then Oracle support shrug their shoulders and laugh at you.

normal parm - see above

hee hee

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse