Home / Installation/Configurations10g / Difference between P-File and SP-File?

Difference between P-File and SP-File?

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;

 

 

........Subsribe OracleSolutions.pk........
OracleSolutions.pk is exclusively meant to guide the newbies to Learn and Share.

About oracle.solutions

Check Also

ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old

ERROR ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old More from my siteHow To …

Leave a Reply