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.

WHAT U WILL DO IF U GOT UPDATE FAILURE IN SM13

4 Answers  

---

1.why we configure the domain controle in production why sap recommended? 2.what is the use of 001 client?

3 Answers   HCL,

---

how can i convert figures into words in sap?pl tell me the function module name?

3 Answers   Pfizer,

---

What types of files are created during the export?

6 Answers  

---

Explain Client Export in SAP?

3 Answers   Cap Gemini,

---

---

How can you find the list of objects that have been repaired in the system?

0 Answers  

---

How to transport users from one client to another?

6 Answers  

---

If the data buffer quality, log buffer Quality <95%, then what should be done by the Basis consultant?

3 Answers   CSC, IBM,

---

Comparison between SAP with any other ERP package avialable in the market

1 Answers   Enteg Technologies,

---

Why dont we apply patche like Transports? (DEV--->QA-->PRD)

2 Answers   CTS,

---

What is Listner?? How to get the status of the Listner?

2 Answers   HCL,

---

what is the user group and use in sap?

3 Answers   Terrenos,

---