TAGS /

Oracle-19c

4 tagged articles
ETL Oracle: from 4 hours to 25 minutes with staging tables, MERGE and parallel DML
Data Warehouse

ETL Oracle: from 4 hours to 25 minutes with staging tables, MERGE and parallel DML

A real Oracle 19c Data Warehouse case: how row-by-row inserts, missing indexes, and frequent COMMITs were killing a nightly ETL batch window.

1 September 2026 8 min
Research on millions of legal documents: how Oracle Text changed response times
Oracle

Research on millions of legal documents: how Oracle Text changed response times

How three Oracle Text indexes cut legal archive search times from 90 seconds to under 700ms. A real case with CONTEXT, CATSEARCH, and CTXXPATH.

11 August 2026 9 min
The lunch break that delayed go-live: Data Governance in the DWH
Data Warehouse

The lunch break that delayed go-live: Data Governance in the DWH

A lunch conversation about what a technically ready Data Warehouse still lacks: data ownership, quality framework, GDPR, TDE on Oracle 19c.

21 July 2026 11 min
ORA-00205 at three in the morning: understanding Oracle critical files before you need to
Oracle

ORA-00205 at three in the morning: understanding Oracle critical files before you need to

Step-by-step diagnosis of ORA-00205 during a night emergency: MOUNT phase, control file, SPFILE, redo log. A practical method for on-call Oracle DBAs.

14 July 2026 12 min