My Oracle Support Banner

Job APEX_190200.ORACLE_APEX_DICTIONARY_CACHE Failed With Error ORA-20901 (Doc ID 2658744.1)

Last updated on FEBRUARY 18, 2021

Applies to:

Oracle Application Express (APEX) - Version 19.2 and later
Information in this document applies to any platform.

Symptoms

On : APEX 19.2 version, Administration

When running the job APEX_190200.ORACLE_APEX_DICTIONARY_CACHE the following error occurs:

ORA-12012: error on auto execute of job "APEX_190200"."ORACLE_APEX_DICTIONARY_CACHE"
ORA-20901: Maximum execution time of 3,600 seconds has been exceeded by run 1600542616620900
ORA-06512: at "APEX_190200.WWV_DICTIONARY_CACHE_DEV", line 2385
ORA-06512: at "APEX_190200.WWV_DICTIONARY_CACHE_DEV", line 2859
ORA-06512: at "APEX_190200.WWV_DICTIONARY_CACHE_DEV", line 3218
ORA-06512: at "APEX_190200.WWV_DICTIONARY_CACHE_DEV", line 3432
ORA-06512: at "APEX_190200.WWV_DICTIONARY_CACHE_DEV", line 3530
ORA-06512: at "APEX_190200.WWV_DICTIONARY_CACHE_DEV", line 3616
ORA-06512: at "APEX_190200.WWV_DICTIONARY_CACHE_DEV", line 3656


The issue can be reproduced at will with the following steps:


1. Check the DB alert logs and traces.

2. Manually run the job using the code below and the same error appears:





Cause

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
Symptoms
Cause
Solution
References


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