NLS parameters

[paddy04]

Hi All,
Does any view provide the information of all NLS parameters thet the system is currently using.

Cheers,

Paddy

[rotem_fo]

Hi,
you can query these views to obtain a list of current NLS parameters in the database:
NLS_SESSION_PARAMETERS;
NLS_INSTANCE_PARAMETERS;
NLS_DATABASE_PARAMETERS;

You can view the entire list of parameters and values using :
V$NLS_PARAMETERS;
V$NLS_VALID_VALUES;

Cheers.