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.

where can u see the dead locks in sap?

4 Answers   Accenture,

---

what are the activity you have done by using solution manager? please explain briefly some activity

1 Answers   IBM,

---

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

1 Answers  

---

How many types of Work Process.and types of roles. how will assign the role to the user.

8 Answers   ATAS, HP,

---

Explain checkpoint?

0 Answers  

---

---

Users are complaining that the SAP system shows a hour glass for a long time at the time of logon and they aren't able to log on to the system and users logged on are complaining of long delays going from t-code to t-code. How can you troubleshoot this problem if you can�t get to SM50 or SM66 or even logon? Why is this?

6 Answers   XYZ,

---

how to assign a object to 100 roles at a time.

2 Answers   Patni, Reliance, Reliance Industries,

---

How to check log running support package?

3 Answers   AXA,

---

Hi, Cansomeone please send the system refresh doc , it's very urgent for me. Thanks in advance.

0 Answers  

---

How do you change five dialog work processes into batch. Where can you do this?

2 Answers  

---

what is role of sap administrator in pi & ep?

0 Answers  

---

How to setup RFC connection in ecc6 tells me steps involved?

0 Answers  

---