database_properties视图

SQL> desc database_properties
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------

 PROPERTY_NAME                             NOT NULL VARCHAR2(30)
 PROPERTY_VALUE                                     VARCHAR2(4000)
 DESCRIPTION                                        VARCHAR2(4000)

select * from database_properties，包涵了下列参数值和描述

DBTIMEZONE
DEFAULT_PERMANENT_TABLESPACE
DEFAULT_TBS_TYPE
DEFAULT_TEMP_TABLESPACE
DICT.BASE
EXPORT_VIEWS_VERSION
GLOBAL_DB_NAME
NLS_CALENDAR
NLS_CHARACTERSET
NLS_COMP
NLS_CURRENCY
NLS_DATE_FORMAT
NLS_DATE_LANGUAGE
NLS_DUAL_CURRENCY
NLS_ISO_CURRENCY
NLS_LANGUAGE
NLS_LENGTH_SEMANTICS
NLS_NCHAR_CHARACTERSET
NLS_NCHAR_CONV_EXCP
NLS_NUMERIC_CHARACTERS
NLS_RDBMS_VERSION
NLS_SORT
NLS_TERRITORY
NLS_TIMESTAMP_FORMAT
NLS_TIMESTAMP_TZ_FORMAT
NLS_TIME_FORMAT
NLS_TIME_TZ_FORMAT

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25843472/viewspace-754451/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25843472/viewspace-754451/