When the database is open issue
sql> show parameter spfile
(or)
sql> select value from v$parameter where name='spfile'
This command gives the location of the spfile ,if the database is started with it.
If the value of the spfile is blank, then spfile is not used to start the instance.
