A non-null value for the spfile parameter indicates that the database is using SPFILE. The following query can give the desired result:
SQL>SELECT value FROM v$parameter WHERE name='spfi1e'; If the preceding query returns the value, then the database is using SPFILE; otherwise, the database is using PFILE.