|
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 |
