Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between pfile and spfile
- 3 Answers
- 9773 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
How should I set priority for Printing say like user, teamlead, project manager?
Explain segment?
You want to find out which users have an access to a particulat transaction. How would you do that?
Can anyone help me in educating me in installing SAP 4.6C over windows server 2000. Please make it a step by step process, my career depends upon the success and failure of installation.
what is netweaver
I am attempting to complete a system copy of bw. When I try to go in to rsa1 afterwards I get the error message, "entry in inbound table already exists." What should I do to solve the problem?
What are the different login and password parameters that can be applied in sap system?
Explain the system trace?
If client copy is stopped in middle, what happens if you want to start it again?
Is it possible to install sap patches when other users are online?
How would you troubleshoot the 'system seems slow'?
How to deactivate IPC in standalone CRM.
What is the procedure to applying patches?
Explain transport domain?
What is sap netweaver administrator tool?
