My Oracle Support Banner

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

Last updated on JULY 29, 2022

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Standard Edition - Version and later
Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


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
 Starting with Oracle Database 12.2, the following code should return the IANA database version installed in the OJVM:
 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.