Question
SPFILE versus PFILE: how do they differ operationally?
Answer
An SPFILE is a server-side binary parameter file Oracle can update persistently. A PFILE is a text initialization file edited outside the instance. Use an SPFILE for managed persistent changes; use a PFILE for bootstrap or recovery from SPFILE problems.