Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between pfile and spfile
- 3 Answers
- 10101 Views
- Wipro, I also Faced
- E-Mail Answers
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
I am installing a sap j2ee engine at crm. When it reaches phase 22 it halts for more than 10 minutes and gives up starting the system. What should I do?
How can you find a list of objects that have been repaired in the system?
Where can you find a list of object keys included in a transport?
TMS Configuration?
Have you done any up gradations?
what is the use of tcode SUSHARE in SAP and how the mass user authorizations compared?
What are the tools to install java patches?
What is XI3.0? Explain XI
What is sap ides?
How to set predecessor relationship between two transport requests?
how would you troubleshoot the 'user can not print'?
If client copy is stopped in middle, what happens if you want to start it again?
what is role of sap administrator in pi & ep?
What is a background processing batch scheduler?
suppose in the landscape there is development, quality, pre-production and production system is there. what is the route(transport route) between pre-production to production? and why?
