what is the difference between pfile and spfile
Answer Posted / abdur rahman, mohammed
THE PFILE
In Oracle 8i, we were using a text file called the PFILE
(parameter file) for setting the database initialization
parameters. This PFILE is read at instance startup time to
get specific instance characteristics. The PFILE is text
based, and can be edited in an editor like vi on UNIX or
Notepad on Windows. Any changes that were made in PFILE
would only take effect when the database is restarted.
THE SPFILE
In Oracle9i, a new feature called SPFILE (server parameter
file) was introduced. SPFILE is a binary file that contains
the same information as the old PFILE. SPFILE permits
dynamic changes without requiring you to restart that
instance.
Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
what is your project architecture?
Suppose you have to integrate sap ecc 6.0 to aws cloud. How can you achieve this?
Explain how client refresh is different than client copy?
What are the different options available for scheduling a background job? What start conditions type can be used?
How do you check the users logs in your system and how many sessions each user is generating?
Hi i am Ramesh want to know that which course in sap is most suitable for my younger brother who has BSC qualification and is this course is job oriented
What are the scripts you can create for security by using LSMW??
Explain what is the use of reference and service user in sap?
What is Unit Testing in SAP?
What is JVM switch. Why JVM switch is required ?
Error in the phase import_proper while applying support packages?
Do? If another user wants to share that lock but the user using that
Explain what are the functional modules used in sequence in bdc?
What is you allocate disks to different areas in sap?
Explain the system trace?