18.9 Adjusting Resources for Background Jobs

Configure a custom job class when background process jobs need different resource limits.

APEX instance administrators who apply resource constraints to ensure a good service for all workspaces and applications can configure a distinct job class for background process jobs if necessary. A DBA user or one with APEX_ADMINISTRATOR_ROLE can execute the following PL/SQL to configure a custom background job process class. For example, this class might enable background jobs to use more resources for longer-running processing use cases.

-- Run as SYS or user with APEX_ADMINISTRATOR_ROLE
begin
   apex_instance_admin.set_parameter(
      p_parameter => 'BACKGROUND_PROCESS_JOB_CLASS',
      p_value     => 'CUSTOM_BG_PROC_CLASS'
   );
end;