Check

SELECT version

FROM v$timezone_file;

SELECT tz_version

FROM registry$database;

SELECT property_name, SUBSTR(property_value, 1, 30) value

FROM database_properties

WHERE property_name LIKE 'DST_%'

ORDER BY property_name;

Update

During a database upgrade the timezone is sometimes be ugraded automatically. If you need to upgrade manually, follow these steps...

(Optional) Identify quantity of timezone data

You can get an idea of the amount of work the upgrade needs to do by running...

sqlplus / as sysdba

@countstatsTSTZ.sql

Large amounts of timezone related data could slow down the upgrade... refer to 1585343.1 for tips on how to address this, if necessary.

Run pre-req check script

This script needs no downtime, and can be executed on a live production database but it WILL purge the dba_recyclebin...

sqlplus / as sysdba

@upg_tzv_check.sql

Upgrade Timezone Data

NOTE: This script will automatically restart the database twice WITHOUT any confirmation or prompt

sqlplus / as sysdba

@upg_tzv_apply.sql

Bibliography