Sunday, January 23, 2011

How I can find a running Oracle database is started using PFILE or SPFILE?


You can check through following ways

Check in v$parameter view

Select * from v$parameter where  upper(name)  like ‘SPFILE’;                              
or
SHOW PARAMETER SPFILE. 


If you find any data in above query then it started using SPFILE else with PFILE.