V$SYSTEM_PARAMETER

Displays information about the initialization parameters that are currently in effect for the instance. A new session inherits parameter values from the instance-wide values.

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

Related:

V$NLS_PARAMETERS
V$NLS_VALID_VALUES
V$PARAMETER
V$SYSTEM_PARAMETER2 - Formatted with one value per row