Wednesday, March 14, 2012

How to check database is using pfile or spfile


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

3 comments: