6 Replies Latest reply on Jul 21, 2010 7:06 PM by Jfuda-Oracle

    Query to determine which time zone file is in use


      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?