V$SPPARAMETER

This view lists the contents of the SPFILE. The view returns NULL values if a PFILE was used to start up the instance.

Column	Datatype	Description
SID	VARCHAR2(80)	SID for which the parameter is defined
NAME	VARCHAR2(80)	Parameter name
VALUE	VARCHAR2(255)	Parameter value
ISSPECIFIED	VARCHAR2(6)	Whether the parameter is specified in SPFILE
ORDINAL	NUMBER	Ordinal number of value if it is in a list of strings
UPDATE_COMMENT	VARCHAR2(255)	Comments for the last update