The SPFILE Initialization Parameter

The SPFILE initialization parameter contains the name of the current server parameter file.

managed it services

When the default server parameter file is used by the database—that is, you issue a STARTUP command and do not specify a PFILE parameter—the value of SPFILE is internally set by the server. The SQL*Plus command SHOW PARAMETERS SPFILE (or any other method of querying the value of a parameter) displays the name of the server parameter file that is currently in use.

mobile app development

Changing Initialization Parameter Values

You can change initialization parameter values to affect the operation of a database instance.

quote

• About Changing Initialization Parameter Values
  The ALTER SYSTEM statement enables you to set, change, or restore to default the values of initialization parameters. If you are using a text initialization parameter file, the ALTER SYSTEM statement changes the value of a parameter only for the current instance, because there is no mechanism for automatically updating text initialization parameters on disk. You must update them manually to be passed to a future instance. Using a server parameter file overcomes this limitation.
• Setting or Changing Initialization Parameter Values
  With a server parameter file, use the SET clause of the ALTER SYSTEM statement to set or change initialization parameter values.

school management