Difference between P-File and 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:
SQL>alter system set resource_limit=true scope=_________;
Where ______ is
BOTH=changes will be applied for current instance and future instance;
MEMORY=changes will be applied only for current instance;
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;