Ability To Query POM Status Tables (Doc ID 3071973.1)

Last updated on FEBRUARY 14, 2025

Applies to:

Goal

Requesting to capture in an efficient manner the status of batch jobs such as failed/long running over a time period for each of the 5 envs we have (DEV1/DEV2/UAT1/STG1/PROD).
Looked at the what is available in POM and its not at the level required nor does it compare across envs.
The ask is can we have read only access to the POM tables that hold this information via APEX SQL Workshop?
Query would be of body:
SELECT job, job_Status,date_St,date_end,etc.
FROM all_need_tables_to_join
WHERE date_range_is

Then we can proper compile this and align internally as currently it is a time consuming manually process which as mention is not efficient which can also be error prone.

 

Solution

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