NUM |
NUMBER |
Parameter number |
NAME |
VARCHAR2(64) |
Parameter name |
TYPE |
NUMBER |
Parameter type; 1 = Boolean, 2 = string, 3 = integer |
VALUE |
VARCHAR2(512) |
Value assigned to the parameter |
ISDEFAULT |
VARCHAR2(9) |
Is the value assigned to the parameter the default |
ISSES_MODIFIABLE |
VARCHAR2(5) |
Whether the parameter can be modified by ALTER SESSION |
ISSYS_MODIFIABLE |
VARCHAR2(9) |
Whether the parameter can be modified by ALTER SYSTEM |
ISMODIFIED |
VARCHAR2(8) |
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) |
Descriptive text about the parameter |