文档id:412160.1
如何查看当前实例的RDBMS DST Patch的版本：
A3) for 10g and 11gR1 query v$timezone_file
SQL> conn / as sysdba
Connected.
SQL> SELECT version FROM v$timezone_file;
VERSION
----------
4
Connected.
SQL> SELECT version FROM v$timezone_file;
VERSION
----------
4
A4) for 11gR2 and higher query v$timezone_file or DATABASE_PROPERTIES
SQL> conn / as sysdba
Connected.
SQL> SELECT version FROM v$timezone_file;
VERSION
----------
14
-- version FROM v$timezone_file should match the DST_PRIMARY_TT_VERSION value found when selecting
SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE 'DST_%'
ORDER BY PROPERTY_NAME;
Connected.
SQL> SELECT version FROM v$timezone_file;
VERSION
----------
14
-- version FROM v$timezone_file should match the DST_PRIMARY_TT_VERSION value found when selecting
SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE 'DST_%'
ORDER BY PROPERTY_NAME;
-- the output gives
-- PROPERTY_NAME VALUE
-- ------------------------------ ------------------------------
-- DST_PRIMARY_TT_VERSION <current DST version>
-- DST_SECONDARY_TT_VERSION 0 <<<<------ this should be "0" if not then see point 3a) in note 977512.1 (for 11gR2) or note 1509653.1 (for 12c)
-- DST_UPGRADE_STATE NONE <<<<------ this should be "NONE" if not then see point 3a) in note 977512.1 (for 11gR2) or note 1509653.1 (for 12c)
