Home » Server Options » Replication » dbms_job (oracle , 9.2.0.6)
dbms_job [message #519260] Wed, 10 August 2011 09:56 Go to next message
sathik
Messages: 196
Registered: August 2009
Location: INDIA
Senior Member
There are 3 databases named sm01,sm02 and sm03. All are resides in different servers.

Job_queue_processes=5 in all 3 databases.

There is a schema called sas_owner in all databases. There are 2853,6801,7 jobs are in SAS_OWNER schema in these 3 databases respectively.

my proplem is, the job I have scheduled in SAS_OWNER schema resides in sm01 and sm02 are not running automatically. But if I run manually, it is running fine.

But in sm03 the jobs are running automatically. no issues in sm03.


So I am planning to increase the value of job_queue_processes in sm01 and sm02. But I dont know what value I need to put for this parameter. is there any calculation to assign a value for this parameter?

[Updated on: Wed, 10 August 2011 10:06]

Report message to a moderator

Re: dbms_job [message #519262 is a reply to message #519260] Wed, 10 August 2011 10:08 Go to previous messageGo to next message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How many jobs run at the same time? This will give you the number.

Regards
Michel
Re: dbms_job [message #519264 is a reply to message #519262] Wed, 10 August 2011 10:15 Go to previous messageGo to next message
sathik
Messages: 196
Registered: August 2009
Location: INDIA
Senior Member
but in my local db, I tested as below.

Job_queue_processes=1

I created 14 jobs as below. Only the job id value I have given differently. These 14 jobs are executing propely even job_queue_processes=1 . in that case how we can say no of job_queue_processes=no of job at a time.

BEGIN
DBMS_JOB.isubmit (
job => 101,
what => 'insert into abc values (1);',
next_date => sysdate,
interval => 'sysdate+15/86400');
commit;
end;
/
Re: dbms_job [message #519267 is a reply to message #519264] Wed, 10 August 2011 11:04 Go to previous messageGo to next message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dbms_job.isubmit does not exist (for you).
NEVER EVER use it.
And I don't see any reason why you use this.
Start by correctly use the package and Oracle then you will have less problems.

Regards
Michel

[Updated on: Wed, 10 August 2011 11:05]

Report message to a moderator

Re: dbms_job [message #519367 is a reply to message #519267] Thu, 11 August 2011 08:00 Go to previous message
babuknb
Messages: 1703
Registered: December 2005
Location: NJ
Senior Member

And also, Instead looking job queue process why your job not started automatically? Did you done any troubleshoot?

Previous Topic: Meterialized view
Next Topic: Oracle Streams vs SharePlex
Goto Forum:
  


Current Time: Sun Apr 20 05:08:18 CDT 2014

Total time taken to generate the page: 0.07791 seconds