René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

NLS related static dictionary views

nls_database_parameters

This view reflects the setting of NLS parameters in the init.ora at the time of the creation of the database.

nls_instance_parameters

This view reflects the setting of NLS parameters in the init.ora (or spfile) that was in effect when the instance was started up.

nls_session_parameters

This view reflects the NLS parameters as set in the session level with something like: 
alter session set <a href='http://www.adp-gmbh.ch/ora/admin/init_params/nls.html'>&lt;nls-parameter&gt;</a>.