SQL results format differs between servers.

[smoothyc]

Here's a good one. I've been losing sleep over something I hope is very simple:

Formatting from SQL*Plus is different between Test and Prod. DB. When I execute a simple "show parameter NLS" command on test it comes back nice and neat, on production it looks as if it's wrapping.

I have looked and compared EVERY PARAMETER that I know of (the obvious ones I checked first "linesize", "pagesize").

If I change the linesize on production from 80 to 100 then the format is nice and neat (even though test's linesize is still 80). I don't want to have two different linesizes per server if possible.

The different formatting is killing my monitoring queries.

Here's an Example:
When I execute the "show paramater NLS" here are the results:

Test:

SQL> show parameter nls

NAME TYPE VALUE
------------------------------------ ----------- --------------------------
nls_calendar string
nls_comp string
nls_currency string
nls_date_format string
nls_date_language string
nls_dual_currency string
nls_iso_currency string
nls_language string AMERICAN
nls_length_semantics string BYTE
nls_nchar_conv_excp string FALSE
nls_numeric_characters string

NAME TYPE VALUE
------------------------------------ ----------- --------------------------
nls_sort string
nls_territory string AMERICA
nls_time_format string
nls_time_tz_format string
nls_timestamp_format string
nls_timestamp_tz_format string


Production:
SQL> show parameter nls

NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
nls_calendar string

nls_comp string

nls_currency string

nls_date_format string

nls_date_language string

NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------

nls_dual_currency string

nls_iso_currency string

nls_language string
AMERICAN
nls_length_semantics string
BYTE

NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
nls_nchar_conv_excp string
FALSE
nls_numeric_characters string

nls_sort string

nls_territory string
AMERICA
nls_time_format string

NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------

nls_time_tz_format string

nls_timestamp_format string

nls_timestamp_tz_format string

SQL>