PLEASE IGNORE THE POSTING AT THE BOTTOM - i was looking at session
parameters. All servers are setup as below :-
NLS_LANGUAGE = AMERICAN
NLS_TERRITORY = AMERICA
NLS_CURRENCY = $
NLS_ISO_CURRENCY = AMERICA
NLS_NUMERIC_CHARACTERS = .,
NLS_CHARACTERSET = WE8ISO8859P1
NLS_CALENDAR = GREGORIAN
NLS_DATE_FORMAT = DD-MON-RR
NLS_DATE_LANGUAGE = AMERICAN
NLS_SORT = BINARY
NLS_TIME_FORMAT = HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT = DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT = HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT = DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY = $
NLS_COMP = BINARY
NLS_LENGTH_SEMANTICS = BYTE
NLS_NCHAR_CONV_EXCP = FALSE
NLS_NCHAR_CHARACTERSET = AL16UTF16
NLS_RDBMS_VERSION = 9.2.0.8.0
n 27 Jul, 15:20, Johne_uk <edg..._at_tiscali.co.uk> wrote:
> One server is in the UK and the slow one in the US. Both servers have
> the same NLS settings (see below). However, I believe the unix Server
> in the US has its locale set to the US - is this a potential issue?
>
> rgds
>
> NLS_LANGUAGE = ENGLISH
> NLS_TERRITORY = UNITED KINGDOM
> NLS_CURRENCY = £
> NLS_ISO_CURRENCY = UNITED KINGDOM
> NLS_NUMERIC_CHARACTERS = .,
> NLS_CALENDAR = GREGORIAN
> NLS_DATE_FORMAT = DD-MON-RR
> NLS_DATE_LANGUAGE = ENGLISH
> NLS_SORT = BINARY
> NLS_TIME_FORMAT = HH24.MI.SSXFF
> NLS_TIMESTAMP_FORMAT = DD-MON-RR HH24.MI.SSXFF
> NLS_TIME_TZ_FORMAT = HH24.MI.SSXFF TZR
> NLS_TIMESTAMP_TZ_FORMAT = DD-MON-RR HH24.MI.SSXFF TZR
> NLS_DUAL_CURRENCY = ¿
> NLS_COMP = BINARY
> NLS_LENGTH_SEMANTICS = BYTE
> NLS_NCHAR_CONV_EXCP = FALSE
Received on Fri Jul 27 2007 - 09:34:23 CDT
