Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 869
  • Last Modified:

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
0
sam2929
Asked:
sam2929
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
What version of Oracle are you using?
0
 
slightwv (䄆 Netminder) Commented:
Also from a sqlplus prompt:
Show parameter job_queue_processes
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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now