Re: values in init.ora

Pete Desnoyers <peted_at_infi.net> writes:

[...]
>Where can I determine whether or not a parameter file entry is fixed
>once I have created the instance? For example, if I set db_block_size
>to 2048, I cannot change this value. I have looked in the server
>reference which is very helpful for the values, but if a parameter file
>entry is static, I have no way knowing.

db_block_size is the only parameter (that I know of at least!) that is fixed upon database create. Other config params may require recreating the control file etc, but they can still be changed.

--

---
Nathan D. Hughes <nhughes_at_well.com>
Computer Consultants of America, Inc.