what is the difference between pfile and spfile

Answer Posted / 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.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How you connect ECC to EP?

1602


What is development class? Why to create the development class?

608


I would like to know the version or name of SAP that is implemented in real time?

672


Have u applied patches what is the transaction code?

640


What is the different type of users in sap?

675






If client copy is stopped in middle, what happens if you want to start it again?

1607


What is upgrade process? And how u will do that?

1263


Explain deletion flag. Where is it used in archiving process?

591


What is the use of kernel in sap system? How do you check the current kernel version in sap system?

616


If possible send me screenshot doc for installation of ecc6

1264


What is password policy?

786


what is your project architecture?

1643


How to deactivate IPC in standalone CRM.

2575


Why we execute SGEN, which Tables it modifies,will it cause DB growth? is it possible to execute SGEN later on after Golive?

2720


what is the procedure for java stack upgradation?

1890