Oracle
Allen 2023-04-17 0 15434 0 0 0 0
Oracle19c,Oralce10g,Oracle10g和19c数据库属性对比

Oracle10g和19c数据库属性对比

Property_name10g19cDESCRIPTION
DBTIMEZONE00:000DB time zone
DEFAULT_EDITIONORA$BASEName of the database default edition
DEFAULT_PERMANENT_TABLESPACEUSERSUSERSName of default permanent tablespace
DEFAULT_TBS_TYPESMALLFILESMALLFILEDefault tablespace type
DEFAULT_TEMP_TABLESPACETEMPTEMP_T0Name of default temporary tablespace
DICT.BASE22dictionary base tables version #
DICTIONARY_ENDIAN_TYPELITTLEEndian type of the data dictionary
DST_PRIMARY_TT_VERSION32Version of primary timezone data file
DST_SECONDARY_TT_VERSION0Version of secondary timezone data file
DST_UPGRADE_STATENONEState of Day Light Saving Time Upgrade
EXPORT_VIEWS_VERSION88Export views revision #
Flashback Timestamp TimeZoneGMTFlashback timestamp created in GMT
GLOBAL_DB_NAMEdb01db01Global database name
LOCAL_UNDO_ENABLEDTRUEtrue if local undo is enabled
MAX_PDB_SNAPSHOTS8maximum number of snapshots for a given PDB
MAX_STRING_SIZESTANDARDMAX_STRING_SIZE parameter used for dictionary metadata
NLS_CALENDARGREGORIANGREGORIANCalendar system
NLS_CHARACTERSETZHS16GBKZHS16GBKCharacter set
NLS_COMPBINARYBINARYNLS comparison
NLS_CURRENCY$$Local currency
NLS_DATE_FORMATDD-MON-RRDD-MON-RRDate format
NLS_DATE_LANGUAGEAMERICANAMERICANDate language
NLS_DUAL_CURRENCY$$Dual currency symbol
NLS_ISO_CURRENCYAMERICAAMERICAISO currency
NLS_LANGUAGEAMERICANAMERICANLanguage
NLS_LENGTH_SEMANTICSBYTEBYTENLS length semantics
NLS_NCHAR_CHARACTERSETAL16UTF16AL16UTF16NCHAR Character set
NLS_NCHAR_CONV_EXCPFALSEFALSENLS conversion exception
NLS_NUMERIC_CHARACTERS.,.,Numeric characters
NLS_RDBMS_VERSION10.2.0.4.019.0.0.0.0RDBMS version for NLS parameters
NLS_SORTBINARYBINARYLinguistic definition
NLS_TERRITORYAMERICAAMERICATerritory
NLS_TIMESTAMP_FORMATDD-MON-RR HH.MI.SSXFF AMDD-MON-RR HH.MI.SSXFF AMTime stamp format
NLS_TIMESTAMP_TZ_FORMATDD-MON-RR HH.MI.SSXFF AM TZRDD-MON-RR HH.MI.SSXFF AM TZRTimestamp with timezone format
NLS_TIME_FORMATHH.MI.SSXFF AMHH.MI.SSXFF AMTime format
NLS_TIME_TZ_FORMATHH.MI.SSXFF AM TZRHH.MI.SSXFF AM TZRTime with timezone format
NO_USERID_VERIFIER_SALTE4FA6F27C073C7D5C89D3E2FBCA3D0C7Per database random key for computing faux salt
OLS_OID_STATUS0OLS OID Status used for Label Security
TDE_MASTER_KEY_ID
WORKLOAD_CAPTURE_MODECAPTURE implies workload capture is in progress
WORKLOAD_REPLAY_MODEPREPARE implies external replay clients can connect; REPLAY implies workload replay is in progress
DICT.BASE2dictionary base tables version #

end;


Tag: Oracle19c Oralce10g
我也要发一个   ·   返回首页   ·   返回[Oracle]   ·   前一个   ·   下一个
欢迎评论
未登录,
请先 [ 注册 ] or [ 登录 ]
(一分钟即可完成注册!)
返回首页     ·   返回[Oracle]   ·   返回顶部