Partition Exchange

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

By | September 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, [...]

Learning About Exchange Partition Mechanism – Oracle

By | February 22nd, 2015|Oracle|

If you have been involved in creating and managing ETL (Extract, Transformation and Load) processes for datawarehousing environments, you know how time consuming it can be especially when data volume is high. One of the best features in Oracle data warehousing is the ability to swap-out standard Oracle tables and partitioned tables. If you are [...]