what is the difference between pfile and spfile
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
What is transport domain?
what is role of sap administrator in pi & ep?
In the Sap Easy Access Menu I see the menu System -> User Profiles ->Own Data. Other options Hold Data is to keep data values that you have entered in a field of an application for the duration of the session; SET DATA not to overwrite the data and DELETE DATA to delete the set data. Can somebody explain me the Hold Data, Set Data and Delete Data with examples, i mean giving an example of fields?
What is the difference between st06 and st03?
How to configure TMS?
How database extend?
How client refresh is different than client copy?
How will go about doing a client copy ?
What is the procedure to applying patches?
Explain transport domain?
What is the use of commit value while deleting jobs in sap system?
What are the pre requisite for the SAP Installation?
can any send unix admin doc? if u have please send it to chanduk29@gmail.com
How to setup RFC connection in ecc6 tells me steps involved?
Hi Shridher, Would you please send me an SAP CRM question and Answer to siri.testing@gmail.com Thanks, siri