My Oracle Support Banner

Which SPFILE Parameter File is Impacted when Issuing an ALTER SYSTEM Command? (Doc ID 138119.1)

Last updated on DECEMBER 11, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Generic UNIX



  You maintain several SPFILE files:

  $ ls -l spfile*
  -rw-r-----   1 sme      dba         2560 Mar 20 08:20 spfile.ora
  -rw-r-----   1 sme      dba         2560 Mar 20 08:20 spfile<SID>.ora

  Which one is modified when you run the "ALTER SYSTEM" SQL command to 
  permanently change parameter values in the spfile?



  The DBAs must be cautious when using ALTER SYSTEM command since it permanently  
  modifies an SPFILE parameter file. 

  They need to know which parameter file will be modified.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.