Command to check whether the oracle database is using spfile or pfile

In my today's blog I will demonstrate you to verify whether your database is using spfile or pfile while startup.

spfile- Server parameter file and it is a binary file.

Pfile-  Parameter file and it is normal text file.

Parameter file is a file which signifies the characteristics of an Instance.

Whenever the Oracle Database startup, it will always to check the parameter file for memory assign.

Parameter contains the list of parameters and value assigned to them.

Now here how you check whether your database is using spfile or pfile to open.





The above information are fetching through the parameter file only.

Command  to check whether the oracle database is using spfile or pfile.

sql> select name,value from V$parameter where name like 'spfile' order by name;

 

  If you can closely observed in the value field I have a path.

Note: 
 
This is suggesting that the oracle database is opened using spfile, if the value is blank then our database is opened in the pfile.



Thank you and have fun !!