Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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