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.
|
| 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.