?
Solved

alter system error

Posted on 2011-02-25
4
Medium Priority
?
837 Views
Last Modified: 2012-05-11
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
Comment
Question by:sam2929
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34985378
What version of Oracle are you using?
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 34985379
Also from a sqlplus prompt:
Show parameter job_queue_processes
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 34985837
the parameter name is plural, you had it singular

alter system set job_queue_processes=20
0
 
LVL 3

Expert Comment

by:gopisera
ID: 34985894
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question