Talking in Tongues – NLS with dbms_scheduler

I’ve implemented enterprise scheduling with dbms_scheduler at an international customer. All is working like a charm, until some jobs started ‘talking’ the local lingo (dutch).

The simple answer is that a submitted scheduler job stores the NLS session settings along with the job definition when creating a scheduler job. To (more...)

PGA tour: Maximize workareas for ETL in Oracle 11.2.0.3

When massaging large volumes of data into your datawarehouse, it is necessary to give the database the maximum resources available to get the job done in time. Our setup consists of a 2s12c24t blade with 48G of memory running Oracle linux 5.7 with a 11.2.0.3 database. (more...)