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
At os level how you can change the number of work process? How you can analyze the status of work process at os level?
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?
What is the purpose of table tadir?
What is transport layer and domain controller? In which system you have create domain control?
can u explain step by step procedure of DB REFRESH..Ravi
I also wanna work with Webdynpros? What are the requirements? I mean SAP 4.7 ee or ECC 5 or 6? Netweaver developer Studio? Also with win 2003 i have the activation problem every month. SO do i get a cd that doesnt ask for the activation? i have win 2000 but can it be installed on HP pavilion laptops that are coming preinstalled with Vista OS?
How can you define login policy for users in sap system?
How database extend?
Using Tc SGEN I have generated 74% job and later I have terminated the job. I wish to start generating from where it stopped I have refreshed but to no chance, nothing was done. How should I further proceed so as to complete the remaining job?
How do you create an instance?
What is private mode? When does user switch to user mode?
Can any one tell me , what is the role of SAP Security Admin in BW Security and APO Security ?
Explain what is “data sets” in sap?
Why we execute SGEN, which Tables it modifies,will it cause DB growth? is it possible to execute SGEN later on after Golive?
What are the different types of rfc and explain what transactional rfc is?