name-value pairs - Oracle Parameters
Columns ___________________________ NUM NAME TYPE VALUE ISDEFAULT ISSES_MODIFIABLE ISSYS_MODIFIABLE ISMODIFIED ISADJUSTED DESCRIPTION UPDATE_COMMENT
The issys_modifiable column shows the type of parameter:
FALSE = Static parameter that cannot change its value in the lifetime of the instance.
IMMEDIATE = dynamic, can change the active instance as well as future database restarts.
DEFERRED = dynamic, changes only affect subsequent sessions.
Related:
List of all init.ora Parameters
Server Parameter Files - Examples - How to Edit
V$NLS_PARAMETERS V$NLS_VALID_VALUES V$SYSTEM_PARAMETER V$PARAMETER2
