First page Back Continue Last page Graphics
Summary
Server Parameter File is often called “SPFILE”
Similar to init.ora file but is in a binary format
Resides on database server
Created with CREATE SPFILE command
Monitored with data dictionary views
Used to allow persistent parameter changes
Can be exported to a text file
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.