Posts Tagged ‘dbms_scheduler’
Copying Oracle Scheduler jobs with Arguments
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 to following scenarios 1)Runaway jobs – When Scheduler job is running [Read More]
User Sessions stuck on resmgr:cpu quantum wait event
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 and our cpu load average was touching 60 Checking active resource plan, we found that DEFAULT_MAINTENANCE_PLAN [Read More]
DBMS_SCHEDULER jobs not running?
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 have already seen it. But for others and also for my future reference I am mentioning it here [Read More]
