Christian Gohmann is currently working as Tech Architecture Associate Manager and Instructor at Accenture in Dusseldorf, Germany. His main focus lies in helping customers in the areas of architecture planning, implementation, and migration – with a specialization in high availability solutions, like Data Guard and Oracle RAC. Since 2006, Christian Gohmann has been working with Oracle and the Oracle Database and worked on various projects for customers in German-speaking areas. Besides his consultancy activities, he is the main developer and the responsible person for db*BACKUP – a product distributed by Accenture, which is responsible for the intelligent backup and recovery of an Oracle database. In his spare time, he shares his knowledge on his blog https://www.christian-gohmann.de and spends as much time as possible with his dog Taran, and for his hobbies climbing/bouldering, hiking, and watching movies. |
During contech2024Deep Dive into the DBMS Scheduler
Deep Dive into the DBMS Scheduler – Abstract: Every DBA should already be familiar with the execution of a procedure or PL/SQL block directly in the Oracle database using the DBMS Scheduler. But this is only a fraction of the functionalities that the DBMS Scheduler supports. This deep dive takes a closer look at the DBMS Scheduler. In addition to the actual implementation and control, the following functions are examined in more detail. – Job chains – Event-driven and file-watcher jobs – Remote Scheduler Agent for executing jobs in a remote database – Logging and e-mail notifications – Interaction with the operating system To conclude the presentation, the integration of the DBMS Scheduler into graphical tools such as SQL Developer or Enterprise Manager Cloud Control will be demonstrated. |