Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query to determine which time zone file is in use

J. Fuda-OracleJul 21 2010 — edited Jul 21 2010

Hi,

From SQL how can I tell which timezone file (timezlrg.dat or timezone.dat) a db is currently using? I don't have access to the server so I can't inspect the ORA_TZFILE env. variable.

When I do a "select count(*) from v$timezone_names ;" I get 1458. Would that be the number of timezones defined in the small file or the large file?

This post has been answered by BobLilly on Jul 21 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 18 2010

Added on Jul 21 2010

#general-database-discussions

6 comments

15,299 views