Oracle19c,Oralce10g,Oracle10g和19c数据库属性对比
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;
Tag: Oracle19c Oralce10g