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;