list_nls_db_parameters.txt

Owned by Chris Lawless (Unlicensed)
Last updated: Feb 17, 2017
1 min read

This file contains the output of the Oracle Data Dictionary view NLS_DATABASE_PARAMETERS.  This information may useful when looking to troubleshooting problems.


Sample file:

NLS_DATABASE_PARAMETERS
SELECT parameter, value FROM NLS_DATABASE_PARAMETERS 

	PARAMETER			VALUE
     ------------------------------- -------------------------------
	NLS_RDBMS_VERSION		12.1.0.2.0
	NLS_NCHAR_CONV_EXCP		FALSE
	NLS_LENGTH_SEMANTICS		BYTE
	NLS_COMP			BINARY
	NLS_DUAL_CURRENCY		$
	NLS_TIMESTAMP_TZ_FORMAT		DD-MON-RR HH.MI.SSXFF AM TZR
	NLS_TIME_TZ_FORMAT		HH.MI.SSXFF AM TZR
	NLS_TIMESTAMP_FORMAT		DD-MON-RR HH.MI.SSXFF AM
	NLS_TIME_FORMAT			HH.MI.SSXFF AM
	NLS_SORT			BINARY
	NLS_DATE_LANGUAGE		AMERICAN
	NLS_DATE_FORMAT			DD-MON-RR
	NLS_CALENDAR			GREGORIAN
	NLS_NUMERIC_CHARACTERS		.,
	NLS_NCHAR_CHARACTERSET		AL16UTF16
	NLS_CHARACTERSET		WE8MSWIN1252
	NLS_ISO_CURRENCY		AMERICA
	NLS_CURRENCY			$
	NLS_TERRITORY			AMERICA

formation may useful when looking into why conflicts happen.


Sample file: