If Oracle Scheduler is mysteriously not running

If you, like me, have stumbeled into trouble with the Scheduler not running jobs, you might realize that there are several ways to disable the Oracle scheduler. The parameter job_queue_processes is just one of them.

The more cunning one is that there’s a parameter, SCHEDULER_DISABLED, visible in the view¬†dba_scheduler_global_attribute.

Continue reading “If Oracle Scheduler is mysteriously not running”

Speeding up large data-transfers over a db-link

Lately I’ve been working a lot with large bulk-loads of data between Oracle databases. The loading is done over db-links and we needed to speed up some of the loads since parallel DML is not supported in distributed transactions.

Continue reading “Speeding up large data-transfers over a db-link”