Friday, January 29, 2010

database is using pfile or spfile

How can I know whether my database is started using spfile or pfile?

Execute the following query

SQL> SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type"
FROM sys.v_$parameter WHERE name = 'spfile';

If result displays pfile, it means that database has been started with pfile and vice-versa.

No comments:

Post a Comment

Please write your comments here.