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.

some parameters need to be set whiconnecting EP to R/3 system.what are they?

1 Answers   iGate,

---

How do you troubleshoot transport problem?

1 Answers  

---

how to know if there are expensive sql statements running?what will you do then to improve the response time?

3 Answers   Atos Origin,

---

how can u connect sap and non sap systems?

1 Answers   iGate,

---

How to login in to SAP from command level?

2 Answers  

---

How do you create an instance?

0 Answers  

---

What is ocm and how to apply ocm patches?

0 Answers  

---

how sap synchronizes the buffers between the instances of a logon group?

3 Answers   TCS,

---

How to configure regular transactions such as MM01 to view archived data?

2 Answers   IBM,

---

What is the procedure to delete a client?

4 Answers  

---

How to transport users from one client to another?

6 Answers  

---

Basic configuration/ settings after installation of SAP Web AS in standalone SAP-CRM system for web client.

2 Answers   SAP Labs,

---