V$SYSTEM_PARAMETER2

This view lists parameters and parameter values that are currently in effect for this instance of Oracle. A new session inherits parameter values from the system values. Each list parameter value appears as a row in the view.

Presenting the list parameter values in this format enables you to quickly determine the values for a list parameter. For example, if a parameter value is "a,b" looking at V$SYSTEM_PARAMETER does not tell you if the parameter has two values ("a" and "b") or one value ("a, b"). V$SYSTEM_PARAMETER2 makes the distinction between the list parameter values clear.

Column	Datatype	Description
NUM	NUMBER	Parameter number
NAME	VARCHAR2(64)	Parameter name
TYPE	NUMBER	Parameter type: 1: Boolean 2: string 3: integer 4: file 5: reserved 6: big integer
VALUE	VARCHAR2(512)	Parameter value
ISDEFAULT	VARCHAR2(6)	Whether the parameter value is the default
ISSES_MODIFIABLE	VARCHAR2(5)	TRUE - the parameter can be changed with ALTER SESSION FALSE - the parameter cannot be changed with ALTER SESSION
ISSYS_MODIFIABLE	VARCHAR2(9)	IMMEDIATE - the parameter can be changed with ALTER SYSTEM DEFERRED - the parameter cannot be changed until the next session FALSE - the parameter cannot be changed with ALTER SYSTEM
ISMODIFIED	VARCHAR2(8)	Indicates how the parameter was modified. If an ALTER SYSTEM was performed, the value will be MODIFIED.
ISADJUSTED	VARCHAR2(5)	Indicates that the rdbms adjusted the input value to a more suitable value (for example, the parameter value should be prime, but the user input a non-prime number, so the rdbms adjusted the value to the next prime number)
DESCRIPTION	VARCHAR2(64)	A descriptive comment about the parameter
ORDINAL	NUMBER	Shows the position, or ordinal number, of each value in a list of string values. Useful only for parameters whose values are lists of strings.
UPDATE_COMMENT	VARCHAR2(255)	Comments associated with the most recent update