show parameter job_q NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ job_queue_processes integer 10 alter system set job_queue_processes=0 scope=memory; alter system set job_queue_processes=10 scope=memory;