What are the parameter file in oracle ? What is the use?
Answer / 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 |
A transport is imported into QAS in 2 min. time the same transport when imported into PRD is taking more than 20 min. why? What to do?
wat description should be given in creating a role....in description area wat should be given ??
What is an ‘ok’ code? What are the differences an ‘ok’ code to a ‘t-code’?
what is the workbench organiser and customizing organiser in transport ?
Various client copy methods and how you will do them?
what do you monitor in st04?
What is SLD and its usage?
Hi i am Ramesh want to know that which course in sap is most suitable for my younger brother who has BSC qualification and is this course is job oriented
Why we need to apply support packages in 000 client ?
How do you create control file? What is the command?
How to check cpu utilization from o/s level,wat is the command.
On a particular system how you can get a list of the users with development access on a particular system?