ETL using Oracle DBMS_HS_PASSTHROUGH and SQL Server

Harry Dragstra June 12, 2017 Oracle, Databases, DBA Oracle, ODA, Oracle 12, Performance and tuning, PL/SQL No Comments

While I prefer a “loosely coupled architecture” for replication between Oracle and SQL Server, sometimes a direct (database) link cannot be avoided. By using DBMS_HS_PASSTHROUGH for data extraction the …

[Continue Reading...]

Oracle SOA Suite: Want performance? Don’t log so much and clean up your database!

Maarten Smeets June 2, 2017 SOA, Business Process Management (BPM) 1 Comment

The Oracle SOA Suite infrastructure, especially composites, use the database intensively. Not only are the process definitions stored in the database, also a lot of audit information gets written …

[Continue Reading...]

Open Brief aan Oracle Professionals – gun jezelf twee dagen kennismaking met je toekomst – op 15 en 16 juni 2017 bij de OGH TechExperience 2017

Lucas Jellema June 2, 2017 Announce / Events No Comments

Beste Oracle professional, Of je nu Oracle Database ontwikkelaar bent, DBA, ADF ontwikkelaar, BI specialist, of SOA Suite specialist, de nieuwsgierigheid blijft altijd kriebelen. Hoop ik. Je wilt beter …

[Continue Reading...]