alter system error

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
sam2929Asked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Also from a sqlplus prompt:
Show parameter job_queue_processes
0
 
slightwv (䄆 Netminder) Commented:
What version of Oracle are you using?
0
 
sdstuberCommented:
the parameter name is plural, you had it singular

alter system set job_queue_processes=20
0
 
gopiseraCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.