What are advantages of using SPFILE over PFILE?

@ : Home > > Interview Room


  • Parameters in SPFILE are changed dynamically.
  • You can’t make any changes to PFILE when the database is up.
  • SPFILE parameters changes are checked before they are accepted as it is maintained by Oracle server thereby reducing the human typo errors.
Alert me