Oracle DBA

Installation, Configuration & Memory

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.

This is 2 of 23 free samples for Oracle DBA.

More Oracle DBA topic samples