<div>
What version of Oracle are you using?
</div>


<div>
the parameter name is plural, you had it singular<br />
<br />
alter system set job_queue_processes=20
</div>


the parameter name is plural, you had it singular

alter system set job_queue_processes=20

<div>
Yes, &nbsp;the above is correct...<br />
<br />
The range of values if from 0 to 1000<br />
<br />
alter system set job_queue_processes=&lt;Range<wbr />&gt;<br />
<br />
Range&lt;0-1000&gt;<br />
<br />
Multiple instances can have different values if the database lies in RAC
</div>


Yes,  the above is correct...

The range of values if from 0 to 1000

alter system set job_queue_processes=<Range>

Range<0-1000>

Multiple instances can have different values if the database lies in RAC

<div>
<div class="content wysiwyg-content">
Hi <br />
Getting error below while doing alter any idea where it can be wrong.<br />
<br />
SQL&gt; alter system set job_queue_process=20;<br />
alter system set job_queue_process=20<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;*<br />
ERROR at line 1:<br />
ORA-02065: illegal option for ALTER SYSTEM
</div>
</div>


Hi 
Getting error below while doing alter any idea where it can be wrong.

SQL> alter system set job_queue_process=20;
alter system set job_queue_process=20
                 *
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM

alter system error

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.