8.110 V$PARAMETER2
V$PARAMETER2
displays information about the initialization parameters that are currently in effect for the session, with each list parameter value appearing as a row in the view. A new session inherits parameter values from the instance-wide values displayed in the V$SYSTEM_PARAMETER2
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
, then the V$PARAMETER
view does not tell you if the parameter has two values (both a
and b
) or one value (a, b
). V$PARAMETER2
makes the distinction between the list parameter values clear.
Column | Datatype | Description |
---|---|---|
|
|
Parameter number |
|
|
Name of the parameter |
|
|
Parameter type:
|
|
|
Parameter value for the session (if modified within the session); otherwise, the instance-wide parameter value |
|
|
Parameter value in a user-friendly format. For example, if the |
|
|
Indicates whether the parameter is set to the default value ( |
|
|
Indicates whether the parameter can be changed with |
|
|
Indicates whether the parameter can be changed with
|
|
|
Indicates whether the parameter can be modified inside a PDB ( In a non-CDB, the value of this column is |
|
|
For parameters that can be changed with |
|
|
Indicates whether the parameter has been modified after instance startup:
|
|
|
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) |
|
|
Indicates whether the parameter has been deprecated ( |
|
|
Indicates whether the parameter is a basic parameter ( |
|
|
Description of the parameter |
|
|
Position (ordinal number) of the parameter value. Useful only for parameters whose values are lists of strings. |
|
|
Comments associated with the most recent update |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also: