Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between pfile and spfile
- 3 Answers
- 9962 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 what is luw (logical unit of work)?
Can any one tell me some real time errors you got for support pack apply, During transport request export-import and for db dackup.
How you connect ECC to EP?
How to uncar car/sar files in a single shot?
What is the difference between – support package, kernel and sap note?
Does any one have SAP basis B1 Resume format for 4 to 5 year experience? if any one have please send me on kishorekharche@gmail.com
What is a developer key? and how to generate a developer key?
Explain segment?
How much swap memory should be in the system?
What is a support package?
How will you define logon groups ? What is load balancing in sap ?
How to perform the transport?
Can any one tell me , what is the role of SAP Security Admin in BW Security and APO Security ?
What are the Pre- requisite for system copy?
Hello Guys, If any body looking for "SAP Vendor Invoice Management (VIM) Training", Please Contact Me,We will covers all SAP VIM topics along with end to end ICC, Document pipeline xECM, Enterprise scan etc. Email ID :kakumanusasikanth@gmail.com
