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 |
TYPE |
VARCHAR2(11) |
Parameter type |
VALUE |
VARCHAR2(255) |
Parameter value (null if a server parameter file was not used to start the instance) |
DISPLAY_VALUE |
VARCHAR2(255) |
Parameter value in a user-friendly format. For example, if the VALUE column shows the value 262144 for a big integer parameter, then the DISPLAY_VALUE column will show the value 256K. |
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) |