ORA_TZFILE

Specifies the location of time zone file.

Each file contains:

• Valid time zone names

• Offset from UTC

• Abbreviation for standard time

• Abbreviation for daylight savings time

The default value is

ORACLE_HOME\oracore\zoneinfo\timezlrg_11.dat

The timezone_version_number.dat data files contain most commonly used time zones and are smaller for better database performance. The new default, timezlrg_version_number.dat, includes time zones not defined in the smaller file.

See Also:

Oracle Database Globalization Support Guide for additional details about time zone files