Answer Detail: RE: what is the difference between spfile and pfile?

GeekInterview.com > Interview Questions > Oracle Apps > Basics

Print |

Question: what is the difference between spfile and pfile?

August 08, 2007 08:49:04	#1
Salil	Member Since: Visitor Total Comments: N/A
RE: what is the difference between spfile and pfile?
spfile is a binary file ans pfile is a text file. We can change parameter in spfile dynamically but we cant change pfile dynamically ...to change parameter in pfile we need to bounce the instance.