Saturday, April 5, 2014

How to check if Oracle DB is started by spfile or pfile


Below is the code that can be used to check

SELECT DECODE (VALUE, NULL, 'PFILE', 'SPFILE')
"Init File Type"
FROM V$PARAMETER
WHERE NAME = 'spfile';

No comments:

Post a Comment