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

can anyone tellme java instance startup sequence?

9115


How to find users used transaction codes which are not authorized for?

1886


What is the difference between developer trace, system log and system trace?

689


what is the difference between with core

1243


In the Sap Easy Access Menu I see the menu System -> User Profiles ->Own Data. Other options Hold Data is to keep data values that you have entered in a field of an application for the duration of the session; SET DATA not to overwrite the data and DELETE DATA to delete the set data. Can somebody explain me the Hold Data, Set Data and Delete Data with examples, i mean giving an example of fields?

3384






Explain the architecture of sap system with different layers. What is the use of gateway?

615


How many types of work processes?

670


Explain checkpoint?

569


steps to congigure CMS in XI ?

1755


I want to change five dialog work processes into batch. Where can I do this?

710


How to create RFC CONNECTION between production server and Global trade system. what prerequsite we need for this.

3173


Which transaction do you use to check buffer statistics ?

705


How you connect ECC to EP?

1598


hi friends, in sap screen with 000 client i unable to logon,with 001 client i can login but i want to log on with 000 client how i can loggin with 000 client intial screen ,please can u help me

6077


What is the difference between consolidation and development route ?

741