What are the main benefits of using SPFILE over PFILE?
devquora
Posted On: Feb 22, 2018
- Oracle 9i or higher version provides SPFILE.
- SPFILE's parameters are changed vigorously.
- It is not possible to make any changes to PFILE at the time of database is up.
- It is not possible for RMAN to backup PFILE while possible to backup SPFILE.
- Typing errors in SPFILE are diminished because the file is checked before its submission and it is managed by the servers of Oracle.
Related Questions
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL Interview Questions
- jQuery Interview Questions
- C Programming Interview Questions
- AngularJs Interview Questions
- Node JS Interview Questions
- JavaScript Interview Questions
- Core Java Interview Questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview Questions
Oracle DBA Interview Questions
What do you understand by the Oracle?
Oracle is a database company that stores the data. Oracle stores the data in a very definite way so that client can regain it in a multi-user condition...
Oracle DBA Interview Questions
What do you mean by Oracle Database?
Oracle has the main theme of storing, creating and managing the database...
Oracle DBA Interview Questions
What do you mean by Oracle DBA and what is its role?
DBA stands for the Database administrator. DBA has the proper rights that can add or remove new users...