Database Administration (MOSC)

MOSC Banner

Monitoring DBA_SCHEDULER_JOBS

I’ve come across a problem when using our monitoring scripts, with the adoption of Apex 23.1, and what it’s doing to DBA_Scheduler. These scripts are sql code called from ksh scripts. My coding skills aren’t up to it, and I’ve been trying to get a solution for a few days and not getting very far. The database is 19.20

The issue is that there is a new job in 23.1 (ORACLE_APEX_BG_PROCESSES), that runs every couple of minutes, but if the database is in the state of closing, the job status is recorded as “STOPPED” and adds to the failure_count in DBA_SCHEDULER jobs. When the database is restarted, the job kicks in again and completes successfully.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center