OraFAQ Forum: Server Administration » Advantages of using DBMS_schedular ovet dbms

Home » RDBMS Server » Server Administration » Advantages of using DBMS_schedular ovet dbms_job (oracle Database 10g Enterprise Edition, Release 10.2.0.5.0 - 64bit,Redhat Enterprice LInux-5.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Advantages of using DBMS_schedular ovet dbms_job [message #568341]

Thu, 11 October 2012 01:19

AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai

Member

Dear All,

Please note,today we had one problem one of oracle job scheduled using dbms_job was inactive for so long time,As one of our developer noticed this and reached me as i checked the dba_job was running without an process



SQL> select sid,serial#,paddr from gv$session where osuser='oracle';

       SID    SERIAL# PADDR
---------- ---------- ----------------
       626        753

i suggested a developer to drop job and reschedule it,now question was raised from them why process was not allocated to job,and can you any one suggests dbms_schedular can over come this problem please adivce.

Regards,
Anil

Report message to a moderator

Re: Advantages of using DBMS_schedular ovet dbms_job [message #568343 is a reply to message #568341]

Thu, 11 October 2012 01:27

AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai

Member

Also note my job_queue_process was given to 500 which is sufficient for our environment

Report message to a moderator

Re: Advantages of using DBMS_schedular ovet dbms_job [message #568344 is a reply to message #568341]

Thu, 11 October 2012 01:31

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

why process was not allocated to job,

You did not give enough information to allowa a diagnosis.

Quote:

can you any one suggests dbms_schedular can over come this problem

As we can't know the origin of the problem (is there actually any problem or just a misconfiguration?) we can't say.

Check your alert.log.

In the meantime, you can read DBMS_JOB and DBMS_SCHEDULER.

Regards
Michel

[Updated on: Thu, 11 October 2012 03:54]

Report message to a moderator

Re: Advantages of using DBMS_schedular ovet dbms_job [message #568361 is a reply to message #568344]

Thu, 11 October 2012 02:52

AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai

Member

Dear Michel,

Thanks,Also note we faced same issue few days before where our dba_job was blocked by another user session after lock was released my job was gone ideal(paddr was not allocated to session).hope same problem happens in this case also In alert log we didnt get any related broken job.

Note:

Repeat interval for job was 10 mins.my job was blocked by another session more than 10mins

Regards,
Anil

Report message to a moderator

Re: Advantages of using DBMS_schedular ovet dbms_job [message #568365 is a reply to message #568361]

Thu, 11 October 2012 03:05

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So you have a job that must be executed every 10 minutes but lasts more than 10 minutes => problem.

Regards
Michel

Report message to a moderator

Re: Advantages of using DBMS_schedular ovet dbms_job [message #568373 is a reply to message #568365]

Thu, 11 October 2012 03:43

AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai

Member

Dear Michel,

My problem is if job runs more than 10mins it just going inactive(paddr-process not allocating to my job).

Regards,
Anil

Report message to a moderator

Re: Advantages of using DBMS_schedular ovet dbms_job [message #568374 is a reply to message #568373]

Thu, 11 October 2012 03:55

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes this is expected as Oracle cannot achieve what you want.
If you want to execute a job then wait 10 minutes and execute it again (any time it takes) then go to the link I gave and click on the "complex scheduling" link.

Regards
Michel

Report message to a moderator

Previous Topic:	oradmin.exe missing
Next Topic:	fragmentation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 23:56:08 CST 2025