Skip to content
AskDba.org Weblog
  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g10g Articles
    • 11gLists 11gR1/R2 articles
    • 12c
  • Performance
  • About Us
Menu Close
  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g
    • 11g
    • 12c
  • Performance
  • About Us

dbms_scheduler

Home » dbms_scheduler

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…

Continue ReadingCopying Oracle Scheduler jobs with Arguments

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…

Continue ReadingUser Sessions stuck on resmgr:cpu quantum 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…

Continue ReadingDBMS_SCHEDULER jobs not running?
Copyright - OceanWP Theme by OceanWP