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;

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

OracleDBconcept

Tablespace Level Fragmentation

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

Leave a Reply