查询数据库的属性参数
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 property_name ,property_value from database_properties;
PROPERTY_NAME PROPERTY_VALUE ------------------------------ ----------------------------------- DICT.BASE 2 DEFAULT_TEMP_TABLESPACE TEMP DEFAULT_PERMANENT_TABLESPACE USERS DEFAULT_EDITION ORA$BASE Flashback Timestamp TimeZone GMT TDE_MASTER_KEY_ID DST_UPGRADE_STATE NONE DST_PRIMARY_TT_VERSION 14 DST_SECONDARY_TT_VERSION 0 DEFAULT_TBS_TYPE SMALLFILE NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CHARACTERSET AL32UTF8 NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-RR NLS_DATE_LANGUAGE AMERICAN NLS_SORT BINARY NLS_TIME_FORMAT HH.MI.SSXFF AM NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR NLS_DUAL_CURRENCY $ NLS_COMP BINARY NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CONV_EXCP FALSE NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_RDBMS_VERSION 11.2.0.4.0 GLOBAL_DB_NAME TESTDB EXPORT_VIEWS_VERSION 8 WORKLOAD_CAPTURE_MODE WORKLOAD_REPLAY_MODE NO_USERID_VERIFIER_SALT 61FE9A498A8FB6995B77028E02D6C276 DBTIMEZONE 00:00 36 rows selected.