SPFILE

Parameter type	String
Syntax	SPFILE = spfile_name
Default value	ORACLE_HOME/dbs/spfile.ora
Parameter class	Static
Range of values	Any valid SPFILE
Real Application Clusters	Multiple instances should have the same value.

The value of this parameter is the name of the current server parameter file (SPFILE) in use. This parameter can be defined in a client side PFILE to indicate the name of the server parameter file to use.

When the default server parameter file is used by the server, the value of SPFILE is internally set by the server.

The SPFILE resides in the ORACLE_HOMEdbs directory; however, users can place it anywhere on their machine as long as it is specified in a PFILE.

See Also: Oracle9i Database Performance Tuning Guide and Reference for more information about creating the SPFILE