V$SYSTEM_PARAMETER2

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

Columns
   ___________________________
 
   NUM
   NAME
   TYPE
   VALUE
   ISDEFAULT
   ISSES_MODIFIABLE
   ISSYS_MODIFIABLE
   ISMODIFIED
   ISADJUSTED
   DESCRIPTION
   ORDINAL
   UPDATE_COMMENT

Related:

V$NLS_PARAMETERS 
V$NLS_VALID_VALUES 
V$PARAMETER 
V$SYSTEM_PARAMETER


 
Copyright © SS64.com 1999-2019
Some rights reserved