what is the difference between pfile and spfile
- 3 Answers
- 8406 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
How many times bdls transaction executes for 2 clients
Where XML file is generated in solution manager?
Example you have 6 sap application servers, I want to monitor all the application servers. How to configure a CCMS?
How many types of printer you have configured? How do you differentiate between them?
How can you find a list of objects that have been repaired in the system?
you want to take sap backup using brtools. How would you do that?
i am arun, as of now i am working in a power plant. I did B.E mech and have completed PGDC in thermal power plant engineering from NPTI(NATIONAL POWER TRAINING INSTITUTE). I started my career in software oly , as i dono any software languages i got failed in conformation exam. Pls help me , i want to enter software field. in this powerplant field 6 working days for week and holiday is also not sunday, i am not able 2 tc of my family... pls help me how to enter sf fielf. my frds sujjested me 2 try as functional after 2 years. wats the procedure for that... pls pls help me in this issue I have 1 year exp in power plant, i knew mechanical design software. my id : arun0029@gmail.com
What are the regular activities u do in solution manager and how
If possible send me screenshot doc for installation of ecc6
Explain transport domain?
If you have a long-running Job, how do you analyse?
What is the purpose of table tdevc?
Explain logon groups?
What are the key activities that you perform as part of sap basis support?
list some common errors faced with jspm while updating java stcks.and solutions.
