Oracle Parameter Files – Spfile Usage


The parameter file that it used to configure the instance when the database was opened.

When the database is created, the spfile <ORACLE_SID> .ora file is created under the $ ORACLE_HOME / dbs directory by default.

When opening the database, the parameters in this file are read in the “nomount” step and the instance is configured according to these parameters.

Without this file, the database cannot be started.

Image result for oracle spfile


The contents of this file are in binary format and cannot be edited with a normal text editor. We can view the parameters set to this file by querying the V$PARAMETER view via SQL * Plus.

There is one thing to consider when changing parameters.

Parameters are static and dynamic.  Dynamic parameters are immediate parameters that can be applied when the database is open.

Static parameters are parameters that are not immediately valid after they are changed and that we need to close and open our database to be valid.


The $ PARAMETER view has important columns for us. We can see these columns as follows.

desc v$parameter


We can learn the instance parameters of our database from v $ SYSTEM_PARAMETER view.


Next article, i will continue required parameters!

Required Parameters For Oracle Database

See you..



Do you want to learn Oracle Database for Beginners, then read the following articles.

About Deniz Parlak

Hi, i’m Security Data Scientist & Data Engineer at My Security Analytics. I have experienced Advance Python, Machine Learning and Big Data tools. Also i worked Oracle Database Administration, Migration and upgrade projects. For your questions [email protected]

Leave a Reply

Your email address will not be published. Required fields are marked *