Dynamic Performance (V$) Views, 189 of 237

V$SPPARAMETER

V$SPPARAMETER displays information about the contents of the server parameter file. If a server parameter file was not used to start the instance, then each row of the view will contain FALSE in the ISSPECIFIED column.

Column	Datatype	Description
`SID`	`VARCHAR2(80)`	SID for which the parameter is defined
`NAME`	`VARCHAR2(80)`	Name of the parameter
`VALUE`	`VARCHAR2(255)`	Parameter value (null if a server parameter file was not used to start the instance)
`ISSPECIFIED`	`VARCHAR2(6)`	Indicates whether the parameter was specified in the server parameter file (`TRUE`) or not (`FALSE`)
`ORDINAL`	`NUMBER`	Position (ordinal number) of the parameter value (`0` if a server parameter file was not used to start the instance). Useful only for parameters whose values are lists of strings.
`UPDATE_COMMENT`	`VARCHAR2(255)`	Comments associated with the most recent update (null if a server parameter file was not used to start the instance)