Code:
SELECT  instance_name,
        DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type" 
FROM    sys.v_$parameter ,
        v$instance
WHERE   name = 'spfile';
INSTANCE_NAME Init F
---------------- ------
gstar SPFILE

[/QUOTE]