Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2002
    Location
    Israel
    Posts
    3

    Unanswered: Change job_queue_processes parameter

    Hi

    Can I Change job_queue_processes Prameter With Alter Syetem
    Commamd , Without changing in init.ora And Down The DB ???

    Thanks

    Roniy

  2. #2
    Join Date
    Jan 2002
    Location
    Winegrape country in California
    Posts
    3
    Hi Roniy

    In Oracle 8i 8.1.7 the job_queue_processes is dynamic, meaning you should be able to change it without bouncing the database. I have not tried myself.

    Good Luck.

  3. #3
    Join Date
    Jan 2002
    Location
    Israel
    Posts
    3

    Change job_queue_processes

    Hi Change job_queue_processes

    Thank U 4 Your Advice But I Use Oracle-7.2.3 ver And The Command
    Alter system set job_queue_processes = 1
    Retrieve Error

    SQL> Alter system set job_queue_processes = 1 ;
    Alter system set job_queue_processes = 1
    *
    ERROR at line 1:
    ORA-02065: illegal option for ALTER SYSTEM

    Can U Explain Why ???

    Thanks

    Roniy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •