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.

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.

Answer / ramanji436

-->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.

How to find list all the T codes for a role in sap?

1 Answers  

---

what is the difference between pfile and spfile

3 Answers   Wipro,

---

AS-IS & TO-BE process, who gets involved?

1 Answers  

---

When support pack is stuck? What you do?

1 Answers  

---

How to check CPU usage in EP? If java path is down the how to do trouble shoot? What is the transport group? What is the SLD system in PI? How to take back up in EP? How to create logical system? Is it possible to change the name logical system in SSC4? How you will take the online Backup and incremental Backup? What is the backup strategy? How many application servers you have in Production System? Difference between oracle 9i and oracle 10g? What is EHP4? What is your enhancement package and support package? how to find RAM size on Unix? How to find OS level at command Prompt? While doing kernel upgrade what is exe files? What is client comparison? How to apply job on Os level? What are the recent challenges faced? How to apply support package in solution manager? Difference between SPDD/SPAU If SAP* is not working ? If job is slow? how you will trouble shoot? What are software files required for SAP 4.7?

0 Answers   iGate,

---

what is the difference between re-do and mirror log? How it is related with database backup? Please explain the database backup concept in detail. Thanks in advance.:) regards preeti.

2 Answers   Accenture,

---

What is the frequency of tapes which you use for backups?

1 Answers   IBM,

---

Do you know logon groups at which situation will be created logon group?

0 Answers  

---

At OS level in which directory Oracle alerts are stored?

5 Answers  

---

what r errors u faced while appling patches

1 Answers  

---

How to solve if more swaps are occurred?

4 Answers   IBM,

---

what post steps and pre steps db refresh

0 Answers   vCentric Technologies,

---