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

Explain what is the purpose of tdevc ?

918


Is there a way to perform sapgui 640 roll out using a centralized server?

811


What are steps for DB Refresh?

1607


steps to congigure CMS in XI ?

1952


What is the use of Trusted system? I know that there is no need of UID and PWD to communicate with partner system. In what situation it is good to go for Trusted system?

850


If job is slow?

1523


How to analysis abap dumps?

866


I need to change the Company address parameters of a user. The path is SU01 -> -> Change - > Address Tab - > Display Icon in Company Address section. In the new screen, i see a preview section icon; on clicking which, I can change the parameters such as "Sending Country"; "Street/PO Box number" and number of lines in the resulting pop up. Here though i change the parameter "Street/PO Box number" field to 'S' ( Street has priority over PO Box), its changing again to 'P' (PO Box has priority over street) only. In the help section it is written that if we set the user parameter (tcode SU3) LND1 to the desired country we can control the user specific Sending Country with the desired value else it takes the Sending Country of the Company defined by default. But no such parameter has been given for Street/PO Box number so that we could change its value atleast there. Someone suggest me how to change the Street/PO Box number of the Address format for a user to the desired value.

4781


Where will you change the parameters in three profiles?

911


Explain the system log?

845


Explain logon groups?

908


What are the different user types in sap system that an admin can use while creating a new user?

851


How database extend?

1639


What is the system's configuration required to implement SAP.

1125


What is the difference between consolidation and development route ?

992