dbms_scheduler Archives - AskDba.org Weblog

Copying Oracle Scheduler jobs with Arguments

Post author:Amit Bansal
Post published:8 February, 2012
Post category:10g / 11g
Post comments:1 Comment

Oracle provides dbms_scheduler.copy_job function to copy oracle scheduler jobs which works great. But problem is that it cannot copy jobs which have arguments. Need to copy jobs can arise due…

User Sessions stuck on resmgr:cpu quantum wait event

Post author:Amit Bansal
Post published:17 January, 2012
Post category:11g
Post comments:0 Comments

We were experiencing lot of session getting stuck on resmgr:cpu quantum in our database. In fact at a time we had 70 sessions which were stuck on this wait event…

DBMS_SCHEDULER jobs not running?

Post author:Amit Bansal
Post published:15 June, 2010
Post category:10g
Post comments:2 Comments

I came across this posting on OTN which lists down things to check in case your scheduler job is not . This is quite old and many of you would…