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

What is the use of patches in sap system? Could you name few common patch types?

693


i am working with NBFC- MNC in personal loan dept. I applied for Internal Job Position in banking Division. My overall (10 years) experience in sales and People Management and in Internal Job Posting they require person for backend activity. There will be not repotees and its individual performance job. My Question is 1. If they will ask why you want to change your field form sales to backend job what should I answer? 2. The opening is in Chennai and since 10 year I am in Gujarat so if they ask why you want to change your home town location? Arpan Thakkar

2337


In my portal ABAP + JAVA I get a bootstrap error message how do I resolve this erroe

4303


What is XI3.0? Explain XI

736


if i want to limit the condition record validity for forst 10 orders how can i do tht plz ans i hve interview in 2/3 days

1528






How can I restrict the user from printing?

633


What is oracle Architecture?

1668


what are the pros and cons of auto extend of table spaces?

1708


What is a support package?

579


Explain the developer trace?

590


What will happen during the export process?

1514


Mention what is the difference between sdm and jspm?

670


what is role of sap administrator in pi & ep?

1655


What is the difference between kernel replacement and support package?

711


What is the purpose of tdevc ?

942