My Oracle Support Banner

Testing your Oracle JVM Time Zone Setup (Doc ID 416860.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Database - Standard Edition - Version and later
Oracle Database - Enterprise Edition - Version and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
*** Checked for relevance on 05-Apr-2016 ***


This document provides a Java Stored Procedure (and wrappers) that can be used for 2 purposes when applying Oracle JVM (OJVM) Time Zone patches. The procedure can be used during the process of deciding whether a OJVM is functional, or it can be used to check if the patch was applied correctly.
It cannot help you in estimating if the OJVM timezone data is actually used.


There are several updates to the Oracle JVM time zone data available from Oracle, an overview is in <Note 412160.1> Updated Time Zones in Oracle Time Zone File patches

The procedure provided in this note can be used to tests the existence of these OJVM updates in the Oracle database and what OJVM DST version is installed.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Testing the OJVM before applying time zone updates
 Testing the OJVM after time zone updates have been applied

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.