BigdataLyn's TECH Blog! 刀不磨要生锈,人不学习要落后 - Thinking ahead

Oracle ADW database_properties Tips

2019-05-07

Oracle ADW database_properties Tips

Oracle ADW 数据库属性 Tips

ADW database_properties

Oracle 19c 的output

SYS> col PROPERTY_NAME for a40
SYS> col DESCRIPTION for a100
SYS> select PROPERTY_NAME,DESCRIPTION from database_properties order by 1;

PROPERTY_NAME				 DESCRIPTION
---------------------------------------- ----------------------------------------------------------------------------------------------------
DBTIMEZONE				 DB time zone
DEFAULT_EDITION 			 Name of the database default edition
DEFAULT_PERMANENT_TABLESPACE		 Name of default permanent tablespace
DEFAULT_TBS_TYPE			 Default tablespace type
DEFAULT_TEMP_TABLESPACE 		 Name of default temporary tablespace
DICT.BASE				 dictionary base tables version #
DICTIONARY_ENDIAN_TYPE			 Endian type of the data dictionary
DST_PRIMARY_TT_VERSION			 Version of primary timezone data file
DST_SECONDARY_TT_VERSION		 Version of secondary timezone data file
DST_UPGRADE_STATE			 State of Day Light Saving Time Upgrade
EXPORT_VIEWS_VERSION			 Export views revision #
Flashback Timestamp TimeZone		 Flashback timestamp created in GMT
GLOBAL_DB_NAME				 Global database name
MAX_PDB_SNAPSHOTS			 maximum number of snapshots for a given PDB
MAX_STRING_SIZE 			 MAX_STRING_SIZE parameter used for dictionary metadata
NLS_CALENDAR				 Calendar system
NLS_CHARACTERSET			 Character set
NLS_COMP				 NLS comparison
NLS_CURRENCY				 Local currency
NLS_DATE_FORMAT 			 Date format
NLS_DATE_LANGUAGE			 Date language
NLS_DUAL_CURRENCY			 Dual currency symbol
NLS_ISO_CURRENCY			 ISO currency
NLS_LANGUAGE				 Language
NLS_LENGTH_SEMANTICS			 NLS length semantics
NLS_NCHAR_CHARACTERSET			 NCHAR Character set
NLS_NCHAR_CONV_EXCP			 NLS conversion exception
NLS_NUMERIC_CHARACTERS			 Numeric characters
NLS_RDBMS_VERSION			 RDBMS version for NLS parameters
NLS_SORT				 Linguistic definition
NLS_TERRITORY				 Territory
NLS_TIMESTAMP_FORMAT			 Time stamp format
NLS_TIMESTAMP_TZ_FORMAT 		 Timestamp with timezone format
NLS_TIME_FORMAT 			 Time format
NLS_TIME_TZ_FORMAT			 Time with timezone format
NO_USERID_VERIFIER_SALT 		 Per database random key for computing faux salt
TDE_MASTER_KEY_ID
WORKLOAD_CAPTURE_MODE			 CAPTURE implies workload capture is in progress
WORKLOAD_REPLAY_MODE			 PREPARE implies external replay clients can connect; REPLAY implies workload replay is in progress

39 rows selected.

SYS> 

ADW 18c 的 output

ADMIN@adwdemo01_high> col PROPERTY_NAME for a40
ADMIN@adwdemo01_high> col DESCRIPTION for a100
ADMIN@adwdemo01_high> select PROPERTY_NAME,DESCRIPTION from database_properties order by 1;
AUTOMATIC_TABLESPACE_CALLOUT             PL/SQL function for automatic tablespace assignment during DDLs
DBTIMEZONE                               DB time zone
DEFAULT_EDITION                          Name of the database default edition
DEFAULT_PERMANENT_TABLESPACE             Name of default permanent tablespace
DEFAULT_TBS_TYPE                         Default tablespace type
DEFAULT_TEMP_TABLESPACE                  Name of default temporary tablespace
DICT.BASE                                dictionary base tables version #
DICTIONARY_ENDIAN_TYPE                   Endian type of the data dictionary
DST_PRIMARY_TT_VERSION                   Version of primary timezone data file
DST_SECONDARY_TT_VERSION                 Version of secondary timezone data file
DST_UPGRADE_STATE                        State of Day Light Saving Time Upgrade
EXPORT_VIEWS_VERSION                     Export views revision #
Flashback Timestamp TimeZone             Flashback timestamp created in GMT
GLOBAL_DB_NAME                           Global database name
LOCAL_UNDO_ENABLED                       true if local undo is enabled
MAX_PDB_SNAPSHOTS                        maximum number of snapshots for a given PDB
MAX_PDB_STORAGE                          Maximum Space Usage of Datafiles and Local Tempfiles in Container
MAX_STRING_SIZE                          MAX_STRING_SIZE parameter used for dictionary metadata
NLS_CALENDAR                             Calendar system
NLS_CHARACTERSET                         Character set
NLS_COMP                                 NLS comparison
NLS_CURRENCY                             Local currency
NLS_DATE_FORMAT                          Date format
NLS_DATE_LANGUAGE                        Date language
NLS_DUAL_CURRENCY                        Dual currency symbol
NLS_ISO_CURRENCY                         ISO currency
NLS_LANGUAGE                             Language
NLS_LENGTH_SEMANTICS                     NLS length semantics
NLS_NCHAR_CHARACTERSET                   NCHAR Character set
NLS_NCHAR_CONV_EXCP                      NLS conversion exception
NLS_NUMERIC_CHARACTERS                   Numeric characters
NLS_RDBMS_VERSION                        RDBMS version for NLS parameters
NLS_SORT                                 Linguistic definition
NLS_TERRITORY                            Territory
NLS_TIMESTAMP_FORMAT                     Time stamp format
NLS_TIMESTAMP_TZ_FORMAT                  Timestamp with timezone format
NLS_TIME_FORMAT                          Time format
NLS_TIME_TZ_FORMAT                       Time with timezone format
NO_USERID_VERIFIER_SALT
NO_USERID_VERIFIER_SALT_COPY
OLS_OID_STATUS                           OLS OID Status used for Label Security
PATH_PREFIX                              All paths for objects such as directories are relative to this
PDB_AUTO_UPGRADE                         upgrade a PDB on PDB open
PDB_UPGRADE_SYNC                         upgrade a PDB using sync
SSL_WALLET                               Location of SSL Wallet
SYNC_ERROR_HANDLER                       schema.package.function of handler called by Application Sync
TDE_MASTER_KEY_ID
WORKLOAD_CAPTURE_MODE                    CAPTURE implies workload capture is in progress
WORKLOAD_REPLAY_MODE                     PREPARE implies external replay clients can connect; REPLAY implies workload replay is in progress

49 rows selected.

ADMIN@adwdemo01_high>

区别:相差10个参数

[oracle@inst01 ~]$ diff oracle_adw18c_db_properties.txt oracle_19c_db_properties.txt
< AUTOMATIC_TABLESPACE_CALLOUT             PL/SQL function for automatic tablespace assignment during DDLs
< LOCAL_UNDO_ENABLED                       true if local undo is enabled
< MAX_PDB_STORAGE                          Maximum Space Usage of Datafiles and Local Tempfiles in Container
< NO_USERID_VERIFIER_SALT_COPY
< OLS_OID_STATUS                           OLS OID Status used for Label Security
< PATH_PREFIX                              All paths for objects such as directories are relative to this
< PDB_AUTO_UPGRADE                         upgrade a PDB on PDB open
< PDB_UPGRADE_SYNC                         upgrade a PDB using sync
< SSL_WALLET                               Location of SSL Wallet
< SYNC_ERROR_HANDLER                       schema.package.function of handler called by Application Sync
[oracle@inst01 ~]$

Have a good work&life! 2019/05 via LinHong


Similar Posts

Comments