Allen 2023-04-17 0 22153 0 0 0 0

---

Oracle10g和19c数据库属性对比

Property_name	10g	19c	DESCRIPTION
DBTIMEZONE	00:00	0	DB time zone
DEFAULT_EDITION		ORA$BASE	Name of the database default edition
DEFAULT_PERMANENT_TABLESPACE	USERS	USERS	Name of default permanent tablespace
DEFAULT_TBS_TYPE	SMALLFILE	SMALLFILE	Default tablespace type
DEFAULT_TEMP_TABLESPACE	TEMP	TEMP_T0	Name of default temporary tablespace
DICT.BASE	2	2	dictionary base tables version #
DICTIONARY_ENDIAN_TYPE		LITTLE	Endian type of the data dictionary
DST_PRIMARY_TT_VERSION		32	Version of primary timezone data file
DST_SECONDARY_TT_VERSION		0	Version of secondary timezone data file
DST_UPGRADE_STATE		NONE	State of Day Light Saving Time Upgrade
EXPORT_VIEWS_VERSION	8	8	Export views revision #
Flashback Timestamp TimeZone		GMT	Flashback timestamp created in GMT
GLOBAL_DB_NAME	db01	db01	Global database name
LOCAL_UNDO_ENABLED		TRUE	true if local undo is enabled
MAX_PDB_SNAPSHOTS		8	maximum number of snapshots for a given PDB
MAX_STRING_SIZE		STANDARD	MAX_STRING_SIZE parameter used for dictionary metadata
NLS_CALENDAR	GREGORIAN	GREGORIAN	Calendar system
NLS_CHARACTERSET	ZHS16GBK	ZHS16GBK	Character set
NLS_COMP	BINARY	BINARY	NLS comparison
NLS_CURRENCY	$	$	Local currency
NLS_DATE_FORMAT	DD-MON-RR	DD-MON-RR	Date format
NLS_DATE_LANGUAGE	AMERICAN	AMERICAN	Date language
NLS_DUAL_CURRENCY	$	$	Dual currency symbol
NLS_ISO_CURRENCY	AMERICA	AMERICA	ISO currency
NLS_LANGUAGE	AMERICAN	AMERICAN	Language
NLS_LENGTH_SEMANTICS	BYTE	BYTE	NLS length semantics
NLS_NCHAR_CHARACTERSET	AL16UTF16	AL16UTF16	NCHAR Character set
NLS_NCHAR_CONV_EXCP	FALSE	FALSE	NLS conversion exception
NLS_NUMERIC_CHARACTERS	.,	.,	Numeric characters
NLS_RDBMS_VERSION	10.2.0.4.0	19.0.0.0.0	RDBMS version for NLS parameters
NLS_SORT	BINARY	BINARY	Linguistic definition
NLS_TERRITORY	AMERICA	AMERICA	Territory
NLS_TIMESTAMP_FORMAT	DD-MON-RR HH.MI.SSXFF AM	DD-MON-RR HH.MI.SSXFF AM	Time stamp format
NLS_TIMESTAMP_TZ_FORMAT	DD-MON-RR HH.MI.SSXFF AM TZR	DD-MON-RR HH.MI.SSXFF AM TZR	Timestamp with timezone format
NLS_TIME_FORMAT	HH.MI.SSXFF AM	HH.MI.SSXFF AM	Time format
NLS_TIME_TZ_FORMAT	HH.MI.SSXFF AM TZR	HH.MI.SSXFF AM TZR	Time with timezone format
NO_USERID_VERIFIER_SALT		E4FA6F27C073C7D5C89D3E2FBCA3D0C7	Per database random key for computing faux salt
OLS_OID_STATUS		0	OLS OID Status used for Label Security
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
DICT.BASE		2	dictionary base tables version #

end;

【版權聲明】
本文爲原創，遵循CC 4.0 BY-SA版權協議！轉載時請附上原文鏈接及本聲明。
原文鏈接：https://tdlib.com/am.php?t=n6jlipimoxXy Tag: Oracle19c Oralce10g

評論

相關內容

歡迎評論