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 is the difference between pfile and spfile

Answer Posted / sumit lohan

In Oracle 8i, we were using a text file called the PFILE
(parameter file) for setting the database initialization
parameters. This PFILE is read at instance startup time to
get specific instance characteristics. The PFILE is text
based, and can be edited in an editor like vi on UNIX or
Notepad on Windows. Any changes that were made in PFILE
would only take effect when the database is restarted.

THE SPFILE
In Oracle9i, a new feature called SPFILE (server parameter
file) was introduced. SPFILE is a binary file that contains
the same information as the old PFILE. SPFILE permits
dynamic changes without requiring you to restart that
instance.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is transport domain?

1878


what is role of sap administrator in pi & ep?

2507


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?

3877


What is the difference between st06 and st03?

1991


How to configure TMS?

1883


How database extend?

1967


How client refresh is different than client copy?

1330


How will go about doing a client copy ?

1125


What is the procedure to applying patches?

1201


Explain transport domain?

1024


What is the use of commit value while deleting jobs in sap system?

1130


What are the pre requisite for the SAP Installation?

2106


can any send unix admin doc? if u have please send it to chanduk29@gmail.com

2033


How to setup RFC connection in ecc6 tells me steps involved?

2189


Hi Shridher, Would you please send me an SAP CRM question and Answer to siri.testing@gmail.com Thanks, siri

1862