Dynamic Performance (V$) Views, 219 of 238

V$SYSTEM_PARAMETER2

V$SYSTEM_PARAMETER2 displays information about the initialization parameters that are currently in effect for the instance, with each list parameter value appearing as a row in the view. A new session inherits parameter values from the instance-wide values.

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, then the V$SYSTEM_PARAMETER view does not tell you if the parameter has two values (both 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)`	Name of the parameter
`TYPE`	`NUMBER`	Parameter type: `1` - Boolean `2` - String `3` - Integer `4` - Parameter file `5` - Reserved `6` - Big integer
`VALUE`	`VARCHAR2(512)`	Parameter value
`ISDEFAULT`	`VARCHAR2(6)`	Indicates whether the parameter is set to the default value (`TRUE`) or the parameter value was specified in the parameter file (`FALSE`)
`ISSES_MODIFIABLE`	`VARCHAR2(5)`	Indicates whether the parameter can be changed with `ALTER SESSION` (`TRUE`) or not (`FALSE`)
`ISSYS_MODIFIABLE`	`VARCHAR2(9)`	Indicates whether the parameter can be changed with `ALTER SYSTEM` and when the change takes effect: `IMMEDIATE` - Parameter can be changed with `ALTER SYSTEM` regardless of the type of parameter file used to start the instance. The change takes effect immediately. `DEFERRED` - Parameter can be changed with `ALTER SYSTEM` regardless of the type of parameter file used to start the instance. The change takes effect in subsequent sessions. `FALSE` - Parameter cannot be changed with `ALTER SYSTEM` unless a server parameter file was used to start the instance. The change takes effect in subsequent instances.
`ISMODIFIED`	`VARCHAR2(8)`	Indicates how the parameter was modified. If an `ALTER SYSTEM` was performed, the value will be `MODIFIED`.
`ISADJUSTED`	`VARCHAR2(5)`	Indicates whether Oracle 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 Oracle adjusted the value to the next prime number)
`DESCRIPTION`	`VARCHAR2(64)`	Description of the parameter
`ORDINAL`	`NUMBER`	Position (ordinal number) of the parameter value. Useful only for parameters whose values are lists of strings.
`UPDATE_COMMENT`	`VARCHAR2(255)`	Comments associated with the most recent update