Oracle 11g

Using Oracle’s Partition Exchange Load for Very Large Target Tables

By |2016-10-31T14:21:27+00:00September 15th, 2015|Oracle|

The situation is very common in Data Integration where a good performing ETL load starts to slow down. The job that been running and loading data just fine, suddenly becomes too slow and becomes a bottleneck. There are many technical explanations for this to happen. Just to name a few, stale statistics, outdated hardware, software, [...]

Benefits and Limitations of Using Virtual Columns in Oracle Database

By |2016-10-31T14:21:27+00:00May 9th, 2015|Oracle|

As the name suggests, Oracle introduced the concept of defining columns on a table that will actually not store values. Instead, it is uses an expression based on other columns in the same table. A very interesting concept. Although these virtual columns appear as normal columns of the table when queried, they are actually not [...]