NUM |
NUMBER |
Parameter number |
NAME |
VARCHAR2(64) |
Parameter name |
TYPE |
NUMBER |
Parameter type; 1 = Boolean; 2 = string; 3 = integer |
VALUE |
VARCHAR2(512) |
Parameter value |
ISDEFAULT |
VARCHAR2(9) |
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(10) |
Indicates how the parameter was modified. If an ALTER SESSION was performed, the value will be MODIFIED. If an ALTER SYSTEM (which will cause all the currently logged in sessions' values to be modified) was performed the value will be SYS_MODIFIED |
ISADJUSTED |
VARCHAR2(5) |
Indicates that the rdbms adjusted the input value to a more suitable value (e.g., 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 |