Hello,every one here

My database server is under Windows 2000(Japanese). and my client is Windows 98(Japanese).

when I query from data dictionary , I got following:

select * from NLS_INSTANCE_PARAMETERS

PARAMETER VALUE
--------- -----
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA

select * from NLS_DATABASE_PARAMETERS

PARAMETER VALUE
--------- -----
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA

select * from NLS_SESSION_PARAMETERS

PARAMETER VALUE
--------- -----
NLS_LANGUAGE JAPANESE
NLS_TERRITORY JAPAN


As you see, only parameters in session view were for Japanese.

I don't know what Oracle do for it. And how can I make all sessions use English instead of Japanese or vice versa.

I do not means using Alter session command to do it.

Is there anyone would clarify it for me?

Thank you in advance.