ETL using Oracle DBMS_HS_PASSTHROUGH and SQL Server

Harry Dragstra

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 2 other ETL processes (transformation and load) can be configured and administered with more flexibility, providing an almost acceptable level of […]

Better track the Usage of Database Options and Management Packs, or it will cost you

Harry Dragstra 2

So here it is Oracle announces a license audit, some urgency kicks in and this familiar but also really serious question comes down from management: “Are we using any unlicensed database features“. The seriousness is quite understandable, because if so, the company can look forward to some negotiations with Oracle […]

How About Oracle Database 12c Threaded_Execution

Harry Dragstra

THREADED_EXECUTION Threaded_Execution is an Oracle Database 12c feature aiming to reduce the number of Oracle processes on LINUX. After setting parameter THREADED_EXECUTION on TRUE and a database bounce, most of the background processes are threads within just 6 Oracle processes, where more than 60 processes existed before the bounce. And […]

Oracle 12c STIG Password Generator in PL/SQL

Harry Dragstra 1

Creating or modifying an Oracle Database user password can be done by using any standard password generator you can find on the WEB. But I wanted a password to comply to “ora12c_strong_verify_function”, and this isn’t as easy to generate as you might expect. Though most generators provide options to include […]

Oracle OpenWorld 2016 – Engineered Systems – Announcing MiniCluster S7-2, Exadata SL and ODA X6-2-HA

Lucas Jellema

In addition to offering infrastructure services from the cloud, Oracle continues to extend its line of engineered systems. The high end consists of SuperCluster and Exadata, ExaLogic and Exalytics and allow enterprises that want to continue exploiting their corporate data centers and running large workloads on premises and running private […]

Larry Ellison – Opening Keynote of Oracle Open World 2010 – announcing Exalogic, the cloud in a box.

Lucas Jellema 1

The first major keynote of this year’s Oracle Open World conference was last night – Larry Ellison announcing the Oracle Exalogic machine, the “cloud in a box”. A high end machine that is meant for consolidation (through virtualization) of many applications on a single piece of highly optimized infrastructure.