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;