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.