what is the difference between pfile and spfile
- 3 Answers
- 8964 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / sumit lohan
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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain segment?
What is the use of commit value while deleting jobs in sap system?
the difference between part number and serial number
What is rfc connection?
What is redolog file? Path?
Can you tell me about the landscape migration to cloud ?
In what ways you would know whether a system is unicode or non-unicode?
before doing client copy you have to adjust table space at os level.what is the single command for that?(with out going through all the menu of brtools)
Why we execute SGEN, which Tables it modifies,will it cause DB growth? is it possible to execute SGEN later on after Golive?
What are the different user types in sap system that an admin can use while creating a new user?
What is a support package?
Can you change the profile parameter in the os level? Which one is advisable why?
How to add authorizations, how you will maintain profiles?
What is the difference between kernel replacement and support package?
How many types of work processes are there in sap ?
