What is the difference between pfile and spfile?

Answer Posted / gopi

"p" file is a parameter file DB restart required after changes has done
"s" file is a server parameter file no need of restart

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which are the most frequent errors encountered while dealing with transports ?

984


IN FUNCTIONAL MODULE SD WE UNFORTUNETLY DELETE OUR ONE ITEM CATEGORY "TAN" FOR THAT WE WANT RECOVER IT WHAT ARE THE PROCEDURES. IS THERE ANY PROCEDURES LIKE RECYCLEBIN. TELL US DETAIL PROCEDURES STEP BY STEP PLEASE

1784


Screenshot document for solution manager installation.

1497


How you can assign an object to 100 roles at time?

1095


How to perform a sap-export and import tables in sap from os level?

959






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

2077


How do you distribute the load?

826


Mention the use of personalized tab and parameter tab in user master record?

893


what post steps and pre steps db refresh

2861


what is sox and sod in sap ?

1472


What are the different types of rfc?

783


What is the procedure to applying patches?

789


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.

4704


What do you understand by executing background jobs in sap system?

738


does the Tcode EWZ5 exist in ECC6?I'm using NW2004S SR2 abap engine and EWZ5 doesn't exist in that.so in that case what is the alternative to EWZ5?to see the list of users present in a client but not necessarily logged in and to to lock or unlock them? Thanks.

3631