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 use of account id in logon tab?

1660


i want my company code and controlling area defaut as 'ABC" through out SAP what to do ? and my plantcode also default to some value

1640


What is difference between oracle 9i and oracle 10g?

1330


What is your organization’s security philosophy? What level of security does your data require? How much risk are you willing to assume in each application area?

1500


Is there a difference between user ddic and sap_all/sap_new?

957






i am arun, as of now i am working in a power plant. I did B.E mech and have completed PGDC in thermal power plant engineering from NPTI(NATIONAL POWER TRAINING INSTITUTE). I started my career in software oly , as i dono any software languages i got failed in conformation exam. Pls help me , i want to enter software field. in this powerplant field 6 working days for week and holiday is also not sunday, i am not able 2 tc of my family... pls help me how to enter sf fielf. my frds sujjested me 2 try as functional after 2 years. wats the procedure for that... pls pls help me in this issue I have 1 year exp in power plant, i knew mechanical design software. my id : arun0029@gmail.com

1669


how can i decleare select-options in module pool table control?

3147


How many types of work processes are there in sap ?

638


What are the different options available for scheduling a background job? What start conditions type can be used?

601


Error in the phase import_proper while applying support packages?

1338


What is osp$ mean?

852


What is SSO? How to configure SSO?

1266


What is the difference between kernel replacement and support package?

721


can we give one check for all vendors in automatic payment run? how?

1695


Is sap a database ?

642