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 8.1.7.0 and laterOracle 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
Purpose
PURPOSE
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?
Scope
SCOPE & APPLICATION
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.
Details
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |