Testing your Oracle JVM Time Zone Setup
(Doc ID 416860.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle Database - Standard Edition - Version 18.104.22.168 and later
Oracle Database - Enterprise Edition - Version 22.214.171.124 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|