DB Wiki

Utilises three components

• Scheduler
• Advanced Queueing
• Resource Manager

• JOB_QUEUE_PROCESSES parameter must be set to at least 4
• Resource Manager must be enabled
• CONCURRENT preference of the DBMS_STATS.SET_GLOBAL_PREFS must be MANUAL, AUTOMATIC or ALL

Enable the Resource Manager by specifying a resource plan

SQL> ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = 'DEFAULT_PLAN';

Set the JOB_QUEUE_PROCESSES parameter to a value at least twice the number of CPU cores

SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 8;

Enable Concurrent Statistics by executing the SET_GLOBAL_PREFS procedure

BEGIN
  DBMS_STATS.SET_GLOBAL_PREFS('CONCURRENT','ALL');
END;
/