V$NLS_PARAMETERS shows current value of NLS_DATE_FORMAT. V$PARAMETER shows NLS database parameters set via the init or spfile.

The session settings override the database NLS settings. The value is derived from NLS_TERRITORY value if it is not set.