Systems Engineering and RDBMS

Archive for June 14th, 2007

Database Properties in Oracle

Posted by decipherinfosys on June 14, 2007

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.

Posted in Oracle | Leave a Comment »

 
Follow

Get every new post delivered to your Inbox.

Join 82 other followers