The following query will show a > 0 count for ISSPECIFIED = True if you started the database with an spfile.
select isspecified, count(*)
from v$spparameter
group by isspecified;
ISSPEC COUNT(*)
------ ----------
TRUE 37
FALSE 227
2 rows selected.
*******************************************
keywords: SPFILE spfile
*******************************************
No comments:
Post a Comment