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

how to do system refresh?not the client copy but the-standard-system-refresh.

1844


How to assign a mass Tables in Auth Group by using T-code:se54

1955


describe how to setup a printer in SAP or where they would look to research why a user/users can not print?

836


Hi,My name is Saurabh I have done BMS & currently working in Wipro BPO (1 year). I want to pursue my career in SAP. As I am totally new in the IT field(no course & no experience) Please could you suggest whether to do a certification from Certified institutes or Non Certified institutes.What is the difference? Also, Is MBA necessary to do certification from Certified institutes?

2057


Does any one have SAP basis B1 Resume format for 4 to 5 year experience? if any one have please send me on kishorekharche@gmail.com

1203


Where will you change the parameters in three profiles?

905


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

774


What are the pre requisite for the SAP Installation?

1794


Explain the developer trace?

749


How to perform the transport?

869


How will you define logon groups ? What is load balancing in sap ?

778


On a particular system how you can get a list of the users with development access on a particular system?

867


Hello Guys, If any body looking for "SAP Vendor Invoice Management (VIM) Training", Please Contact Me,We will covers all SAP VIM topics along with end to end ICC, Document pipeline xECM, Enterprise scan etc. Email ID :kakumanusasikanth@gmail.com

1512


Transport request types and its syntax?

2158


Where can you find a list of object keys included in a transport?

806