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.