Exporting the Server Parameter File

You can use the CREATE PFILE statement to export a server parameter file to a text
initialization parameter file. Doing so might be necessary for several reasons:
■ For diagnostic purposes, listing all of the parameter values currently used by an
instance. This is analogous to the SQL*Plus SHOW PARAMETERS command or
selecting from the V$PARAMETER or V$PARAMETER2 views.
■ To modify the server parameter file by first exporting it, editing the resulting text
file, and then re-creating it using the CREATE SPFILE statement[@more@]