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 / abdur rahman, mohammed

THE PFILE

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 ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why we execute SGEN, which Tables it modifies,will it cause DB growth? is it possible to execute SGEN later on after Golive?

3131


what is role of sap administrator in pi & ep?

2080


List the difference between asynchronous and synchronous transport?

964


What is transport domain?

1773


What is an interface in SAP?

1196


What is the difference between – support package, kernel and sap note?

1550


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

1122


Explain how to define logon groups?

1038


What is purpose user group in SU01?

2919


list some common errors faced with jspm while updating java stcks.and solutions.

2565


Explain what is the use of reference and service user in sap?

1008


Hello Guys, If any body looking for "SAP Vendor Invoice Management (VIM) Training", Please Contact Me,We will covers all SAP VIM topics along with end to end ICC, Document pipeline xECM, Enterprise scan etc. Email ID :kakumanusasikanth@gmail.com

1697


What is the use of Trusted system? I know that there is no need of UID and PWD to communicate with partner system. In what situation it is good to go for Trusted system?

1045


Is system user sap basis consultant and dialogue user other user like fico, hr, mm user?

1474


what is netweaver

1483