what is the difference between pfile and spfile
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
-->Below oracle 8 version pfile is there.And contain the database initialization parameters.
Pfile is static parameter file and we can edit by using text editor.For each modification we need to restart the profile for change replications.
-->The spfile also contain db initialization parameters but it is binary file and no need to restart the profile if any changes done.
Is This Answer Correct ? | 1 Yes | 0 No |
Explain the process of Logon Load balancing.
Why do you use DDIC user not SAP* for Support Packs and SPam?
HOW TO TRANSPORT SAME REQUST TO MANY CLIENTS
Where can one see Archived files and what is the Tcode?
How to lock a transaction?
Why is java Required while installing SAP
in the stms screen where do you access transport logs specifically slog,alog,and ulog?
when we applying SAP add-on (while in processing) where we have to check the log file for that implementation?
When applying a support pack to sap system. Can you tell me what errors you are faced are?
2 Answers Span Systems, Terrenos,
Explain Client Export in SAP?
If a tcode is taking too long time to finish and I wand to end the work process in sm50 how to find which work process is currently executing that tcode?
difference between composite role and derived role