Monday, April 21, 2008

Was the Database started with a SPFILE

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: