Difference between P-File and SP-File?
October 20, 2017
Installation/Configurations10g, Installation/Configurations11g, Installation/Configurations12c, Oracle Database Material
Difference between P-File and SP-File?
| P-FILE | SP-FILE |
| It is called as parameter file. | It is called as server parameter file. |
| P-File is ASCII file and it can be edited Manually | spfile is binary file and it cannot be edited Manually |
Parameters can be changed through following options:
1)alter system
2)alter session
Command
SQL>alter system set resource_limit=true scope=_________;
Where ______ is
BOTH=changes will be applied for current instance and future instance;
OR
MEMORY=changes will be applied only for current instance;
OR
SPFILE=changes will be applied after restart the database.
SP-File Can be created with the following command
SQL> create spfile from pfile;
And Vice Versa Pfile can be Created by
SQL> create pfile from spfile;
Related Posts