1C:\users\administrator>sqlplus Sys/[email protected]/ORCL as Sysdba2 3Sql*plus:release 11.2.0.1.0 Production on Saturday December 16 03:51:28 20174 5Copyright (c) 1982, 2010, Oracle. All rights reserved.6 7 8 Connect to:9Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionTen with the partitioning, OLAP, Data Mining and Real application testing options One ASql> Select value from V$parameterWhere name like '%job_queue_processes%' -2 -Sql> alter system Set job_queue_processes = 30 the2 -Sql> alter system Set job_queue_processes = 30; - - The system has changed. + -Sql> Select value from V$parameterWhere name like '%job_queue_processes%'; + A VALUE at-------------------------------------------------------------------------------- - -30 - -Sql> Select value from V$parameterWhere name like '%job_queue_processes% '
Connect to the Oracle database and modify the items required to start a scheduled task job_queue_processes