| NUM | A number that Oracle uses to identify the parameter internally. |
| NAME | The name of the parameter. |
| TYPE | A number representing the parameter type: 1=boolean, 2=string, 3=integer. |
| VALUE | The current value of the parameter. |
| ISDEFAULT | This is TRUE if the parameter's value represents the default setting. Otherwise, this is FALSE. |
| ISSES_MODIFIABLE | This is TRUE if the parameter can be changed for a single user session using the ALTER SESSION command. Otherwise, this is FALSE. |
| ISSYS_MODIFIABLE | This is either IMMEDIATE, DEFERRED, or FALSE. IMMEDIATE means that the parameter can be changed using ALTER SYSTEM, and the change takes effectimmediately. DEFERRED means that a change takes effect only for future user connections. FALSE means that the parameter cannot be changed by usingALTER SYSTEM. |
| ISMODIFIED | Indicates whether a parameter was modified. A value of MODIFIED indicates that ALTER SESSION was used to modify the parameter. A value ofSYS_MODIFIED indicates that ALTER SYSTEM was used to modify the parameter. A value of FALSE indicates that the parameter's value has not beenmodified from that specified in the initialization file. |
| ISADJUSTED | Indicates whether the Oracle software adjusted a parameter setting that you specified. TRUE means that the parameter value was adjusted. FALSEmeans that it wasn't. |
| DESCRIPTION | A short comment describing the parameter's purpose. |
