First page Back Continue Last page Graphics

Summary


Notes:

The server parameter file (spfile) is part of the persistent parameter initialization feature of Oracle9i. It is similar to the parameter file parameter file from earlier versions of Oracle.

The SPFILE is created with the CREATE SPFILE command. You must have the SYSDBA or SYSOPER system privilege to execute the CREATE SPFILE command.

The SPFILE can be used to allow changes made to parameters with the ALTER SYSTEM command to be persistent. See the SCOPE= parameter of the ALTER SYSTEM command.

Initialization parameters for pfiles and spfiles can be monitored with the V$PARAMETER, V$PARAMETER2, and V$SPPARAMETER data dictionary views.

The SPFILE is a binary file. If you want to see the contents of a SPFILE you can export them to a text file using the CREATE PFILE command. You must have the SYSDBA or SYSOPER system privilege to execute this command.