How to check database is running with spfile or pfile

How to check database is running with spfile or pfile | In oracle database there is couple of way to find out whether database is running with spfile or pfile.

How to check database is running with spfile or pfile
How to check database is running with spfile or pfile
Parameter File

How to check database is running with spfile or pfile.

1.SQL> show parameter spfile;
 
After executing above returns blank then database was started using pfile.

2.SQL> select name,value from v$parameter where name=’spfile’;

 
If database running with spfile , it will return the result.
                You may also check below sql query :-
             3. SQL>SELECT DECODE(value, NULL, ‘pfile’, ‘spfile’) “Init_File Type” FROM sys.v_$parameter                        WHERE name = ‘spfile’;
 
If database running by pfile , we can create the spfile from pfile.


You check another similar post, click here.

Leave a Comment