what is the difference between pfile and spfile
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
If job is slow?
What is an “ok” code is and what is the difference between “t-code” and “ok” code?
please share sap basis admin interview questions .. thanks sadik
What are the different types of rfc?
When should we use Transactional RFC?
Hi i am Ramesh want to know that which course in sap is most suitable for my younger brother who has BSC qualification and is this course is job oriented
What is oracle Architecture?
Is there a way to perform sapgui 640 roll out using a centralized server?
Explain segment?
what is role of sap administrator in pi & ep?
suppose in the landscape there is development, quality, pre-production and production system is there. what is the route(transport route) between pre-production to production? and why?
What is the difference between kernel replacement and support package?
Explain what is the use of reference and service user in sap?
Some transactions in sap are seen as customizing, for instance ovrf (updating routes). In some systems this is set as master data and can be set open. Where do you do this?
Can any one tell me , what is the role of SAP Security Admin in BW Security and APO Security ?