数据库一些默认的属性及情况设置查询

select * from DATABASE_PROPERTIES order by 1;

PROPERTY_NAME             PROPERTY_VALUE                           DESCRIPTION
------------------------- ---------------------------------------- ----------------------------------------
DBTIMEZONE                00:00                                    DB time zone
DEFAULT_PERMANENT_TABLESP USERS                                    Name of default permanent tablespace
ACE

DEFAULT_TBS_TYPE          SMALLFILE                                Default tablespace type
DEFAULT_TEMP_TABLESPACE   TEMP                                     Name of default temporary tablespace
DICT.BASE                 2                                        dictionary base tables version #
EXPORT_VIEWS_VERSION      8                                        Export views revision #
GLOBAL_DB_NAME            DBTEST.REGRESS.RDBMS.DEV.US.ORACLE.COM   Global database name
NLS_CALENDAR              GREGORIAN                                Calendar system
NLS_CHARACTERSET          AL32UTF8                                 Character set

PROPERTY_NAME             PROPERTY_VALUE                           DESCRIPTION
------------------------- ---------------------------------------- ----------------------------------------
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    AL16UTF16                                NCHAR Character set
NLS_NCHAR_CONV_EXCP       FALSE                                    NLS conversion exception
NLS_NUMERIC_CHARACTERS    .,                                       Numeric characters

PROPERTY_NAME             PROPERTY_VALUE                           DESCRIPTION
------------------------- ---------------------------------------- ----------------------------------------
NLS_RDBMS_VERSION         10.2.0.1.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

27 rows selected.

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

转载于:http://blog.itpub.net/28612416/viewspace-762753/