Sunday , September 24 2023

How To Check if Oracle instance was started with pfile or spfile

We can learn the parameter file in which the database is opened by querying the spfile and pfile parameter value.

If both the spfile and the pfile file exist under the $ORACLE_HOME/dbs directory, the database will automatically open with the spfile if no parameter file is specified during startup.

If the instance opened with Spfile;

It will show the Spfile.

If the instance opened with Pfile;

It doesnt return any value.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

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