6 Replies Latest reply: Jul 21, 2010 2:06 PM by Jfuda-Oracle RSS

    Query to determine which time zone file is in use

    Jfuda-Oracle
      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?