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 can a client be locked?

6 Answers  

---

1. In which table support pack store....? 2. wht r things happing in back ground during DB backup..?

2 Answers   TCS,

---

If java server got strucked or stopped?

2 Answers  

---

What is the purpose of webdisptcher and Installing and configuring Web Dispatcher what are the prerequisites?

2 Answers   Fujitsu,

---

Apart from Update WP,which WP can also perform update in Database?? When we give print request, which WP comes into the picture??

4 Answers   ABC,

---

Incase my sap system was down (users are unable to login to sap system) how to analyze this problem?

3 Answers  

---

what type of files are created during the export?

6 Answers   Accenture,

---

What is supplementation language?

3 Answers   IBM, TCS,

---

How do you do the load balancing?

2 Answers  

---

what are the jspm related logs that you see at os level at the time of java stack upgradation?

1 Answers   iGate,

---

How to find sap transaction codes?

2 Answers  

---

I want to find all non executed transaction list (user wise) for last three months one option is through st03n but in that i have to find by each and every t-code there is any facility to get this list user wise

3 Answers  

---