V$SYSTEM_PARAMETER
displays information about the initialization parameters that are currently in effect for the instance. A new session inherits parameter values from the instance-wide values.
Column | Datatype | Description |
---|---|---|
NUM |
NUMBER |
Parameter number |
NAME |
VARCHAR2(80) |
Name of the parameter |
TYPE |
NUMBER |
Parameter type:
|
VALUE |
VARCHAR2(512) |
Instance-wide parameter value |
DISPLAY_VALUE |
VARCHAR2(512) |
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 . |
ISDEFAULT |
VARCHAR2(9) |
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:
|
ISINSTANCE_MODIFIABLE |
VARCHAR2(5) |
For parameters that can be changed with ALTER SYSTEm , indicates whether the value of the parameter can be different for every instance (TRUE ) or whether the parameter must have the same value for all Real Application Clusters instances (FALSE ). If the ISSYS_MODIFIABLE column is FALSE , then this column is always FALSE . |
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) |
ISDEPRECATED |
VARCHAR2(5) |
Indicates whether the parameter has been deprecated (TRUE ) or not (FALSE ) |
DESCRIPTION |
VARCHAR2(255) |
Description of the parameter |
UPDATE_COMMENT |
VARCHAR2(255) |
Comments associated with the most recent update |
HASH |
NUMBER |
Hash value for the parameter name |