9.45 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

FAMILY

VARCHAR2(80)

For internal use only

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)

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data