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) |
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) |