Skip to Main Content
Feature Request FR-4125
Product Area APIs
Status DELIVERED

1 Voters

Documentation for ORACLE_APEX_BG_PROCESSES job

samo.decman Public
· Nov 28 2024

Idea Summary
There is a job called ORACLE_APEX_BG_PROCESSES that runs on the database every 2 min. There is no documentation about what that job actually does and if that job can be disabled or at least, run at longer intervals (e.g. hourly).

Use Case
If you have for example a CDB with 10 PDBs and APEX installed on 5 of them, you would need at least JOB_QUEUE_PROCESSES=5 parameter set because there is always one job active per APEX installation. Our DBAs have a tendency keeping the parameter as low as possible, set even to 0 when doing certain administration tasks. What are the ramifications of disabling jobs at database level or disabling this one job in particular? What functionalities in APEX are affected by this?

Preferred Solution (Optional)
-

This has been delivered in Oracle APEX 24.2!

Comments

Comments

  • carsten.czarski APEX Team OP 7 months ago

    Thank you for reporting this. The ORACLE_APEX_BG_PROCESSES job (and also a few others) are indeed missing in the Administration Guide > DBMS_Scheduler Jobs. We'll track as a doc bug.

    I'll follow up with documentation to get these added. Thanks again.

  • ashwin.s.rao APEX Team OP 11 days ago

    This has already been published in the documentation below.

    https://docs.oracle.com/en/database/oracle/apex/24.2/htmdb/understanding-background-page-processing.html#GUID-27F8C574-4B52-463B-AD2A-66B27B249AD9