V$PARAMETER2

Displays information about the initialization parameters that are currently in effect for the session, with each list parameter value appearing as a row in the view. A new session inherits parameter values from the instance-wide values displayed in the V$SYSTEM_PARAMETER2 view.

Columns
   ___________________________
 
   NUM
   NAME
   TYPE
   VALUE
   ISDEFAULT
   ISSES_MODIFIABLE
   ISSYS_MODIFIABLE
   ISMODIFIED
   ISADJUSTED
   DESCRIPTION
   ORDINAL
   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$PARAMETER 


© Copyright SS64.com 1999-2014
Some rights reserved