database_properties

DATABASE_PROPERTIES lists Permanent database properties.

Column	Datatype	NULL	Description
PROPERTY_NAME	VARCHAR2(30)	NOT NULL	Property name
PROPERTY_VALUE	VARCHAR2(4000)		Property value
DESCRIPTION	VARCHAR2(4000)		Property description

SELECT *
FROM database_properties
ORDER BY 1;

PROPERTY_NAME	PROPERTY_VALUE	DESCRIPTION
DBTIMEZONE	-07:00	DB time zone
DEFAULT_PERMANENT_TABLESPACE	USERS	Default Permanent Tablespace ID
DEFAULT_TBS_TYPE	SMALLFILE	Default tablespace type
DEFAULT_TEMP_TABLESPACE	TEMP	ID of default temporary tablespace
DICT.BASE	2	dictionary base tables version #
EXPORT_VIEWS_VERSION	8	Export views revision #
GLOBAL_DB_NAME	testdb.mycom.com	Global database name
NLS_CALENDAR	GREGORIAN	Calendar system
NLS_CHARACTERSET	UTF8	Character set
NLS_COMP	BINARY	NLS comparison
NLS_CURRENCY	$	Local currency
NLS_DATE_FORMAT	DD-MON-RR	Date format
NLS_DATE_LANGUAGE	AMERICAN	Date language
NLS_DUAL_CURRENCY	$	Dual currency symbol
NLS_ISO_CURRENCY	AMERICA	ISO currency
NLS_LANGUAGE	AMERICAN	Language
NLS_LENGTH_SEMANTICS	BYTE	NLS length semantics
NLS_NCHAR_CHARACTERSET	UTF8	NCHAR Character set
NLS_NCHAR_CONV_EXCP	FALSE	NLS conversion exception
NLS_NUMERIC_CHARACTERS	.,	Numeric characters
NLS_RDBMS_VERSION	10.2.0.2.0	RDBMS version for NLS parameters
NLS_SORT	BINARY	Linguistic definition
NLS_TERRITORY	AMERICA	Territory
NLS_TIMESTAMP_FORMAT	DD-MON-RR HH.MI.SSXFF AM	Time stamp format
NLS_TIMESTAMP_TZ_FORMAT	DD-MON-RR HH.MI.SSXFF AM TZR	Timestamp with timezone format
NLS_TIME_FORMAT	HH.MI.SSXFF AM	Time format
NLS_TIME_TZ_FORMAT	HH.MI.SSXFF AM TZR	Time with timezone format