NUM |
NUMBER |
Parameter number |
NAME |
VARCHAR2(64) |
Parameter name |
TYPE |
NUMBER |
Parameter type:
1 : Boolean
2 : string
3 : integer
4 : file
5 : reserved
6 : big 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(8) |
Indicates how the parameter was modified. If an ALTER SYSTEM was performed, the value will be MODIFIED . |
ISADJUSTED |
VARCHAR2(5) |
Indicates that the rdbms 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 the rdbms adjusted the value to the next prime number) |
DESCRIPTION |
VARCHAR2(64) |
A descriptive comment about the parameter |
UPDATE_COMMENT |
VARCHAR2(255) |
Comments associated with the most recent update |