Get Started with Performance Tuning Reactive Database Tuning Using Automatic Workload Repository Warehouse for Generating Performance Reports AWR Warehouse Best Practices Database Best Practices The job_queue_processes Parameter The job_queue_processes Parameter Set JOB_QUEUE_PROCESSES to a value greater than 0. Oracle scheduler jobs are responsible for importing AWR data. Setting the parameter ensures that job slaves are created to run the scheduler jobs.