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 |
Where you monitor the PI messages?
Explain Post Installation Activities??
How to do transports from OS level?
As a basis consultant what are the roles and responsibility's looking in to EP(EP monitoring, and trouble shooting and how to connect please let me some thing anybody plz help me)
What is the procedure to delete a client?
Difference between visual admin and configtool?
Explain central instance?
can we prepare a landscape with ides systems?
How extended memory is allocated?
How to schedule background jobs at OS level?
Have you done any parameter changes using configtool and visual admin tool?
in oracle script @? "?" question mark means what it indicate?