Home » RDBMS Server » Server Administration » Job_queue_processes Parameter is not Changing
Job_queue_processes Parameter is not Changing [message #52872] Mon, 19 August 2002 01:27 Go to next message
Rajesh Naik
Messages: 6
Registered: January 2002
Junior Member
Hi all

I am using Oracle 9i ver- 9.0.1.0.0

Whenever i am changing the Job_queue_processes by using OEM console or through Alter system Command it is changing to the Desired Value, but when i restart the server its again reset to 0.

Even if i change it in init.ora under "ifiles" Directory, it is of no use . Same case for job_queue_interval.

Please help me out

Thanks
Rajesh
Re: Job_queue_processes Parameter is not Changing [message #52880 is a reply to message #52872] Mon, 19 August 2002 04:34 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
with 9i the concept of SPILE's is introduced.
if you change the initsid.ora from OEM the changed
file is stored locally somewhere else.
so eventually, when you start the intsid.ora, it would
not have the changed parameter.
Try changing the parameters in the file that resides in the server.

Previous Topic: Running a Job when Server Starts
Next Topic: Re: ORA-12571: TNS:packet writer failure
Goto Forum:
  


Current Time: Thu Sep 19 18:03:25 CDT 2024