Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

does the Tcode EWZ5 exist in ECC6?I'm using NW2004S SR2 abap engine and EWZ5 doesn't exist in that.so in that case what is the alternative to EWZ5?to see the list of users present in a client but not necessarily logged in and to to lock or unlock them? Thanks.

3922


What is heterogenous system copy and homogenous system copy ?

1056


What is the different type of users in sap?

1097


What is sap netweaver administrator tool?

1104


What will you observe in st06?

1332


What is private mode? When does user switch to user mode?

1186


what is the common storage file for oracle ?

2093


Explain how to define logon groups?

1085


If I want only transaction data to be copied.What profile should I select, while doing local client copy within the same apllication server. Else is there any other way to perform above task?

6859


How you can disable the ‘import all’ button on stms for the queues?

1162


Which are the most frequent errors encountered while dealing with transports ?

1293


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

2163


I'm getting the following runtime error in IDES "DYNPRO_MSG_IN_HELP". GUI is 720 final release and patch level:0

4659


what is netweaver

1537


How do I know what threshold values to set

2117