2020-12-09
Tips for running massive DML in Oracle
When working on a DWH or BI system, massive deletes or, more in general, massive DML and ETL are business…
Yet another Oracle DBA
When working on a DWH or BI system, massive deletes or, more in general, massive DML and ETL are business…
This is a really annoying behavior I saw on both Oracle 12.1 and Oracle 19c. It is not (yet?) a…
Ansible is probably the best Configuration Management tool currently available. In its simplest form it is an agentless automation tool…
Few months ago I’ve found a frustrating issue while I was testing Oracle 19c. We usually set ASM to use…
We have an integrated extractor capturing data from our source Oracle database. It store captured data in local trails and…
You got your database ready and your integrated extractor running. You need some data pump to move your data around.…
Setting up the DB First thing you need a Oracle DB Enterprise Edition 12.1. You need to configure database with…
Architecture As stated in previous posts, the whole picture consists in replicating contents from a Oracle DB to a s3bucket…
Every DBA is doomed to make some scripts and with enough time, they will increase in numbers like thousands if…
In today world, data needs to be moved from one place to another. Usually there are at least two main…