SAP Note 1641320 - NLS* parameters are marked as 'MODIFIED' in V$PARAMETER

Component : Oracle -

Solution : https://service.sap.com/sap/support/notes/1641320 (SAP Service marketplace login required)

Key words :
isdefault  ismodified------------------------ --------- ---------- ----------nls_language            american  true       falsenls_territory            america  true       falsenls_sort                          true       falsenls_date_language                  true      falsenls_date_format                    true      falsenls_currency                      true       falsenls_numeric_characters            true       falsenls_iso_currency                  true       falsenls_calendar                      true       falsenls_time_format                    true      falsenls_timestamp_format              true       falsenls_time_tz_format                true       falsenls_timestamp_tz_format            true       falsenls_dual_currency                  true      falsenls_comp                binary    true       falsenls_length_semantics    byte      true       falsenls_nchar_conv_excp      false    true       false17 rows selected, isdefault  ismodified------------------------ --------------------     ---------- ----------nls_language            american                true       modifiednls_territory            america                  true      modifiednls_sort                binary                  true       modifiednls_date_language        american                true       modifiednls_date_format          dd-mon-rr                true      modifiednls_currency             $                        true      modifiednls_numeric_characters, true       modified                        tzrnls_dual_currency        $                        true      modifiednls_comp                binary                  true       modifiednls_length_semantics    byte                    true       falsenls_nchar_conv_excp      false                    true      false17 rows selected, true       modifiednls_iso_currency         america                  true      modifiednls_calendar             gregorian                true      modifiednls_time_format          hh, format a20col isdefault format a10col ismodified format a10select, tzr       true       modifiednls_timestamp_tz_format  dd-mon-rr hh, true       modifiednls_timestamp_format     dd-mon-rr hh, true       modifiednls_time_tz_format      hh, set pagesize 200set linesize 200col, setting nls_lang affects session parameters

Related Notes :

1431798Oracle 11.2.0: Database Parameter Settings
1171650Automated Oracle DB parameter check