Skip to content

AskDba.org Weblog

  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g
    • 11g
    • 12c
  • Performance
  • About Us

Tag: dbms_scheduler

Amit Bansal

8 February, 2012

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…

Read Full Recipe
47 views 10:43 am 0 Comments
Amit Bansal

17 January, 2012

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…

Read Full Recipe
356 views 3:18 pm 0 Comments
Amit Bansal

15 June, 2010

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…

Read Full Recipe
62 views 10:35 am 2 Comments
Disclaimer!!

This blog reflect our own views and do not necessarily represent the views of our current or previous employers.

The contents of this blog are from our experience, you may use at your own risk, however you are strongly advised to cross reference with Product documentation and test before deploying to production environments.

Recent Comments
  • Prabhav Pushkar on MGMTDB: Grid Infrastructure Management Repository
  • Azure BLOB Storage As Remote Backend for Terraform State File - AskDba.org Weblog on Azure Infrastructure Automation With Terraform: Configuration
  • tolu on 11g: Multiple failed login attempt can block New Application connections
  • venkatesh on Retrieving Database SID,Port information from Grid Control repository
  • Patrick on Solving ORA-1031 while connecting as “/ as sysdba” :
Trending
  • Resolving Shutdown Immediate Hang Situations
  • Recreating Database Link
  • Limiting I/O and CPU resources using 11g Oracle Resource Manager
  • Using SSL to securely connect to Amazon Redshift Cluster
  • Connections to DataBase Hang Including "/ as sysdba"
  • ERRORSTACK- Oracle Debugging Event
  • Simplified Approach to Resolve ORA-4031
Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 188 other subscribers
Proudly powered by WordPress | Tech Blog WordPress Theme by TheMagnifico
TOP