Home » Server Options » Text & interMedia » Increase max num of DBMS jobs
Increase max num of DBMS jobs [message #75900] Fri, 11 January 2002 05:02 Go to next message
martin K.
Messages: 1
Registered: January 2002
Junior Member
I am maintaining a system built around the dbms_job package, punters are now saying there is a problem with the max number of jobs occurring at one time being 20. Is there anyway possible of increasing number ???

Thanks is advance,
Martin.

Report message to a moderator

Re: Increase max num of DBMS jobs [message #75902 is a reply to message #75900] Mon, 14 January 2002 15:49 Go to previous message
lick.china
Messages: 1
Registered: January 2002
Junior Member
ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 30;

Now you can use the command above to increase the job max number and can't reboot the database

Report message to a moderator

Previous Topic: Re: PDE error-message!
Next Topic: Re: convert table definition to DTD for XML documents ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Aug 18 09:26:08 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.