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

How can you view locked transactions?

1089


What is ocm and how to apply ocm patches?

1684


What is the difference between consolidation and development route ?

1350


What is the different type of users in sap?

1105


What are the categories to execute sap background jobs?

1103


Where do you download trail version of sap ecc, what is sap cal?

1099


What is the procedure to applying patches?

1143


you want to take sap backup using brtools. How would you do that?

1161


TMS Configuration?

1884


Why can't we do it thru some other client?

2018


How to assign a mass Tables in Auth Group by using T-code:se54

2334


i am arun, as of now i am working in a power plant. I did B.E mech and have completed PGDC in thermal power plant engineering from NPTI(NATIONAL POWER TRAINING INSTITUTE). I started my career in software oly , as i dono any software languages i got failed in conformation exam. Pls help me , i want to enter software field. in this powerplant field 6 working days for week and holiday is also not sunday, i am not able 2 tc of my family... pls help me how to enter sf fielf. my frds sujjested me 2 try as functional after 2 years. wats the procedure for that... pls pls help me in this issue I have 1 year exp in power plant, i knew mechanical design software. my id : arun0029@gmail.com

2146


What is an interface in SAP?

1257


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

1982


If client copy is stopped in middle, what happens if you want to start it again?

2085