what is the difference between pfile and spfile
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
Hi i have 2.10 yrs of experience on Sap Basis...been working as a sap basis consultant.but unable to get through MNC companies...On what criteria does HR select the candidate.does my academics matter coz they are not good thou i am a B.tech graduate
Explain deletion flag. Where is it used in archiving process?
how can i decleare select-options in module pool table control?
What are common transport errors and their codes?
User wants lock ASAP then what will u do?
What are the tools to install java patches?
What is the use of account id in logon tab?
What is the role of “ application server” ?
what is role of sap administrator in pi & ep?
what is your project architecture?
What are the different user types in sap system that an admin can use while creating a new user?
Explain the system log?
Hi ,All What is the multi-threading and max connections for rfc. Actually i am facing problem while send large amount of idocs to external system using middle ware tibco r3 adapter. And how to enable these in SAP ?
How will u send mail after completion of backup?
can u explain step by step procedure of DB REFRESH..Ravi