Prev: Unifying Temp table behavior across oracle, mssql
Next: Splitting Double Quoted String with Delimiters to Single Quoted character arrays.
From: gzjacklee on 23 Jun 2008 04:59
I used "alter system set nls_sort = binary_ci scope = spfile" to
change the default value of the parameter nls_sort.Then I restarted
the service of the database instance.I saw the instance value has
changed.Now the problem is when I create a new connection the value of
nls_sort was not binary_ci but binary.I don't know why the session
value was not changed.

any advice will be appreciated!

Thanks a lot
Jack.Lee
From: sybrandb on 23 Jun 2008 08:37
On Mon, 23 Jun 2008 01:59:37 -0700 (PDT), gzjacklee(a)gmail.com wrote:

>I used "alter system set nls_sort = binary_ci scope = spfile" to
>change the default value of the parameter nls_sort.Then I restarted
>the service of the database instance.I saw the instance value has
>changed.Now the problem is when I create a new connection the value of
>nls_sort was not binary_ci but binary.I don't know why the session
>value was not changed.
>
>any advice will be appreciated!
>
>Thanks a lot
>Jack.Lee

Instance settings can be, and usually are, overridden by session
specific values.
Oracle always sends a series of alter session statements immediately
after logon.
Those can be changed by setting a registry string value in the correct
hive for Windows, or by setting an environment variable on Unix in
your .profile.
You can also use an execute immediate statement in an after logon
database trigger.

Hth

--
Sybrand Bakker
Senior Oracle DBA
From: gzjacklee on 24 Jun 2008 03:40
On Jun 23, 8:37 pm, sybra...(a)hccnet.nl wrote:
> On Mon, 23 Jun 2008 01:59:37 -0700 (PDT), gzjack...(a)gmail.com wrote:
> >I used "alter system set nls_sort = binary_ci scope = spfile" to
> >change the default value of the parameter nls_sort.Then I restarted
> >the service of the database instance.I saw the instance value has
> >changed.Now the problem is when I create a new connection the value of
> >nls_sort was not binary_ci but binary.I don't know why the session
> >value was not changed.
>
> >any advice will be appreciated!
>
> >Thanks a lot
> >Jack.Lee
>
> Instance settings can be, and usually are, overridden by session
> specific values.
> Oracle always sends a series of alter session statements immediately
> after logon.
> Those can be changed by setting a registry string value in the correct
> hive for Windows, or by setting an environment variable on Unix in
> your .profile.
> You can also use an execute immediate statement in an after logon
> database trigger.
>
> Hth
>
> --
> Sybrand Bakker
> Senior Oracle DBA

I used an after logon trigger.It's done!

Thank u very much!
Jack.Lee
 | 
Pages: 1
Prev: Unifying Temp table behavior across oracle, mssql
Next: Splitting Double Quoted String with Delimiters to Single Quoted character arrays.