Re: How to edit spfile ?/

On 4/26/06, Thomas Day <tomday2_at_gmail.com> wrote:
>
>
> Usually the parameter that I want to change is something that can't be
> changed via ALTER SYSTEM. Very rarely do I get lucky and edit the spfile
> such that the checksum is still valid. The only way that I know of to
> always be able to alter the parameter in spfile is to create a pfile from
> the spfile, edit the pfile, restart the database from the pfile and create
> an spfile from the pfile.
>
> HUGE pain. Not a fan of spfile at all. Only use it when management
> insists.

I think you are likely looking for the SCOPE=SPFILE clause of ALTER SYSTEM

eg ALTER SYSTEM SET PROCESSES=500 SCOPE=SPFILE;

you can add comments and set different parameters for different instances on a cluster as well should you so desire. Apologies if this is a grandmother/egg sucking post.

Though management that dedicates its time to deciding on whether a parameter file should be binary or ascii, lets just say I wonder about the appropriateness of the level at which decisions get taken.

--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l