What is spfile and pfile in oracle

Hi,

In this article, I will explain the parameter files that are very important for Oracle database.

This parameter is created when opening the Oracle instance and then we can change the contents of these parameter files either dynamically or statically.Oracle In our database there are 2 identical parameter files, which are named SPFILE and PFILE.

Create pfile from spfile

Create pfile from spfile

How to check pfile location in oracle

How to check spfile location in oracle

How to check initialization parameters in oracle

Oracle alter system set parameter example

I will examine both of them separately below.

 

SPFILE (Server Parameter File): It is a physical file with .ora extension in binary format where the parameters required for configuring the instance are stored when opening Oracle instance.

This file is typically located under the $ ORACLE_HOME/dbs directory and spfile<ORACLE_SID>.ora format. We can say that this file is Oracle Instance configuration file that all parameters are kept for startup of Oracle instance

You can also find the location of this file from the database as follows.

[oracle@MehmetSalih ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Tue Mar 1 14:26:31 2019 Copyright (

show parameter windows