what is the difference between pfile and spfile
- 3 Answers
- 9010 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
What is MySAP?
What do you understand by executing background jobs in sap system?
What will you observe in st06?
Briefly explain a recent problem you faced, which u felt proud by solving that? And how will u solved?
What is the difference between – support package, kernel and sap note?
How to add authorizations, how you will maintain profiles?
How to perform a sap-export and import tables in sap from os level?
What are the different options available for scheduling a background job? What start conditions type can be used?
you want to take sap backup using brtools. How would you do that?
How will you define logon groups ? What is load balancing in sap ?
If job is slow?
i'm new for security, pls help if assign the t-code to parent it wll effect to child role or not. can we assign to t-code directly to child role? it wll work or not?
Why we execute SGEN, which Tables it modifies,will it cause DB growth? is it possible to execute SGEN later on after Golive?
IN FUNCTIONAL MODULE SD WE UNFORTUNETLY DELETE OUR ONE ITEM CATEGORY "TAN" FOR THAT WE WANT RECOVER IT WHAT ARE THE PROCEDURES. IS THERE ANY PROCEDURES LIKE RECYCLEBIN. TELL US DETAIL PROCEDURES STEP BY STEP PLEASE
what are the current support stack levels at market place?
