Oracle 11g Database Version 11.1.0.7

Dec 24, 2008  Here's a great way to end the year 2008 for Certifications with EBS: Oracle Database 11gR1 version 11.1.0.7 is now certified with E-Business Suite Release 11i. 11.1.0.7 is the first database patchset available for the 11gR1 Release 11.1.0.6. Customers can upgrade to this version. May 13, 2016. Verify that the version is 4, when it is higher or lower than follow Metalink Note: Actions for the DSTv4 update in the 11.1.0.7 patch set ID:568125.1. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application.

1. Oracle 11g Database Version 11.1.0.7 Windows 10
2. Oracle 11g Database Version 11.1.0.7.0

Hi All,
Have anybody tried to change the NLS parameter NLS_LENGTH_SEMANTICS in Oracle 11g (11.1.0.7.0)?
I found a weird behavior:
I tried the following
SQL> col parameter for a30
SQL> col value for a35
SQL> select * from v$nls_parameters where PARAMETER='NLS_LENGTH_SEMANTICS';

PARAMETER VALUE
------------------------------ -----------------------------------
NLS_LENGTH_SEMANTICS BYTE

SQL> alter system set NLS_LENGTH_SEMANTICS = CHAR SCOPE=BOTH SID='*';

System altered.

SQL> select * from v$nls_parameters where PARAMETER='NLS_LENGTH_SEMANTICS';

PARAMETER VALUE
------------------------------ -----------------------------------
NLS_LENGTH_SEMANTICS BYTE

however the show parameter shows the changed value

SQL> show parameter NLS_LENGTH_SEMANTICS;

NAME TYPE VALUE
------------------------------------ ---------- ------------------------------
nls_length_semantics string CHAR

Oracle 11g Database Version 11.1.0.7 Windows 10

Have anybody faced such weird behavior of oracle 11gR1 or if i am doing anything wrong.

---
Sameer Mattoo

Oracle 11g Database Version 11.1.0.7.0