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)
Advantages of using DBMS_schedular ovet dbms_job [message #568341] Thu, 11 October 2012 01:19 Go to next message
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
Re: Advantages of using DBMS_schedular ovet dbms_job [message #568343 is a reply to message #568341] Thu, 11 October 2012 01:27 Go to previous messageGo to next message
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
Re: Advantages of using DBMS_schedular ovet dbms_job [message #568344 is a reply to message #568341] Thu, 11 October 2012 01:31 Go to previous messageGo to next message
Michel Cadot
Messages: 59110
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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
Re: Advantages of using DBMS_schedular ovet dbms_job [message #568365 is a reply to message #568361] Thu, 11 October 2012 03:05 Go to previous messageGo to next message
Michel Cadot
Messages: 59110
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Advantages of using DBMS_schedular ovet dbms_job [message #568373 is a reply to message #568365] Thu, 11 October 2012 03:43 Go to previous messageGo to next message
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
Re: Advantages of using DBMS_schedular ovet dbms_job [message #568374 is a reply to message #568373] Thu, 11 October 2012 03:55 Go to previous message
Michel Cadot
Messages: 59110
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: oradmin.exe missing
Next Topic: fragmentation
Goto Forum:
  


Current Time: Wed Sep 17 10:44:17 CDT 2014

Total time taken to generate the page: 0.09486 seconds