One of the static data dictionary views in Oracle is DATABASE_PROPERTIES which can be used to take a quick look at permanent database properties. Here is the sql and partial result set.
SQL> Column Property_Value FORMAT A30
SQL> SELECT Property_Name, Property_Value
FROM database_properties;
PROPERTY_NAME PROPERTY_VALUE
—————————— ————–
DICT.BASE 2
DEFAULT_TEMP_TABLESPACE TEMP
DEFAULT_PERMANENT_TABLESPACE USERS
DEFAULT_TBS_TYPE SMALLFILE
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8MSWIN1252
This is an easy way to check permanent database properties like default permanent tablespace, default temporary tablespace, nls parameters etc. As the name suggests, all these properties are at database level.
