What are the parameter file in oracle ? What is the use?

Answer Posted / rupesh chavan

There are two types of initialization parameter files exist.

1:PFILE, commonly referred to as initSID.ora
2: SPFILE, commonly referred to as spfileSID.ora

Use

To start an instance, the Oracle server reads the initialization parameter file.

Parameter File Contents

• A list of instance parameters
• The name of the database the instance is associated with
• Allocations for memory structures of the System Global Area (SGA)
• What to do with filled online redo log files
• The names and locations of control files
• Information on undo segments

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between asynchronous and synchronous transport?

608


If job is slow?

1341


What are the activities you done in PI?

2565


Explain how you can restrict multiple logins of user in sap? What are the thing you have to take care of while writing the id’s?

765


Is sap a database ?

632






What do you understand by sap client administration?

607


what are the current support stack levels at market place?

1802


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

1873


How to transport objects from Production to Development?

1674


What is the purpose of webdisptcher and Installing and configuring Web Dispatcher what are the prerequisites?

1977


you want to do a system-copy. List the steps you will take.

573


I have solman 7.1 Stack3. I want to upgrade to stack13. My question is can I directly download stack13 files from marketplace, if yes, will those files includes xml file ? (MOPZ is not configured in my system).

1368


What is the use of commit value while deleting jobs in sap system?

644


describe how SAP handles Memory Management?

645


What are the Pre- requisite for system copy?

1359