what is the difference between pfile and spfile
Answer Posted / ramanji436
-->Below oracle 8 version pfile is there.And contain the database initialization parameters.
Pfile is static parameter file and we can edit by using text editor.For each modification we need to restart the profile for change replications.
-->The spfile also contain db initialization parameters but it is binary file and no need to restart the profile if any changes done.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many types of work processes are there in sap ?
What are the key activities that you perform as part of sap basis support?
I need to change the Company address parameters of a user.
The path is SU01 ->
What are the Parameters need to be set when connecting EP to r/3 system what are they?
Where is the Deletion Flag or Indicator used in archiving process?
What do you understand by transport management in sap basis?
What is the procedure to applying patches?
How to identify a particular T_Code has been modified or not? If yes, how to identify who modified particular T_Code in current system?
How you will give new authorizations?
How to find users used transaction codes which are not authorized for?
What is the difference between asynchronous and synchronous transport?
What is the need of having Development system?
What is the folder it will ask to install oracle?
What is ocm and how to apply ocm patches?
what are the main issues you faced in the implementation project?