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

Difference between P-File and SP-File?

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:

1)alter system

2)alter session


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;

About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also


Tablespace Level Fragmentation

Tablespace Level Fragmentation in Oracle Database Introduction In this article, I will discuss tablespace level …

Leave a Reply