Search This Blog

Total Pageviews

Thursday 18 November 2010

Is oracle database using a PFILE or SPFILE ?

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


Init File Type

------------------
SPFILE


or


SQL> show parameter spfile;

NAME TYPE VALUE

------------------------------------ -------------- -----------
spfile string /opt/oracle/product/10.2/dbs/spfilecccdb.ora

Oracle DBA

anuj blog Archive