dbms_scheduler

What is the most secure way to call an external job from an Oracle (pluggable) database?

I recently asked myself this question after having been confronted with a quite challenging situation, which will be been dissected in this post. Indeed, most of the DBA are aware about several mechanism offered by the Oracle database engine(…)

Why Data Pump Fails to Import Scheduler-Programs

Here is the How To of scripting them instead Oracle Data Pump can import simple programs without arguments, but it fails when handling Scheduler-Programs that contain arguments. This has been a persistent issue with no official resolution. Since this(…)

How to use DBMS_SCHEDULER to improve performance ?

From an application point of view, the oracle scheduler DBMS_SCHEDULER allows to reach best performance by parallelizing your process. Let’s start with the following PL/SQL code inserting in serial several rows from a metadata table to a target table. In(…)

Compression advisor: excessive redo log file generation

Last week by a customer, we experienced an excessive redo log generation filling up rapidly the FRA (Flash/Fast Recovery Area) with archivelog files which caused the database to crash.