Oracle: Server parameter file

Creating an SPFILE

create spfile                            from pfile='/u01/app/oracle/product/nn.n.n/dbhome_1/initORACLE_SID.ora';
create spfile '/u01/oracle/dbs/init.ora' from pfile='/u01/app/oracle/product/nn.n.n/dbhome_1/initORACLE_SID.ora';
create spfile                            from memory;

The scope clause in ALTER SYSTEM SET … statements

alter system set <init_param> = 'value' scope=spfile;
alter system set <init_param> = 'value' scope=memory;
alter system set <init_param> = 'value' scope=both;

Resetting an SPFILE

alter system reset scope=spfile;

Export an SPFILE

create pfile from spfile;

See also