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)
-