what is the difference between pfile and spfile
- 3 Answers
- 8385 Views
- Wipro, I also Faced
- E-Mail Answers
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
Have you done any parameter changes using configtool and visual admin tool?
Why can't we do it thru some other client?
How many types of work processes?
Do you know about oss what do you do with oss?
How you will give new authorizations?
How do you generate (recover) old system logs in a newly created SLOG00?
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 is the need of having Development system?
How you can assign an object to 100 roles at time?
How many times bdls transaction executes for 2 clients
What is GRIR, GRIR effect, why it is imp, How it is analysed, What is expected out GRIR, What is auto write off & Manual GRIR write off?
Where can you find a list of object keys included in a transport?
Explain checkpoint?
Explain the developer trace?
Have you done any up gradations?
