Topic : SPFILE & PFILE

Which file is accessed first when Oracle database is started and What is the difference between SPFILE and PFILE?


Answer :

- Init.ora parameter file or SPFILE is accessed first .( SID is instance name)
- Settings required for starting a database are stored as parameters in this file.
- SPFILE is by default created during database creation whereas PFILE should be

Show Answer Discuss

What are advantages of using SPFILE over PFILE?


Answer :

- SPFILE is available from Oracle 9i and above.
- Parameters in SPFILE are changed dynamically.
- You can?t make any changes to PFILE when the database is up.
- RMAN cant backup PFILE; It can backup SPFILE.
- SPFILE parameters changes are

Show Answer Discuss

How can you find out if the database is using PFILE or SPFILE?


Answer :

- You can query Dynamic performance view (v$parameter) to know your database is using PFILE or SPFILE.
- SQL> select value from V$parameter where name= ?SPFILE?;
- A non-null value indicates the database is using SPFILE.
- Null value indicates

Show Answer Discuss

Where are parameter files stored and how can you start a database using a specific parameter file?


Answer :

- In UNIX they are stored in the location $ORACLE_HOME/dbs and ORACLE_HOME/database for Windows directory.
- Oracle by default starts with SPFILE located in $ORACLE_HOME/dbs.
- If you want to start the database with specific file we can append it

Show Answer Discuss

What is the parameter file?


Answer :

The parameter file is a file that contains additional command-line parameters.

Show Answer Discuss