- 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…
- Reset “log_archive_dest_n” does not revert the Archive destination to “db_recovery_file_dest”
This is a really annoying behavior I saw on both Oracle 12.1 and Oracle 19c. It is not (yet?) a…
- How to create your Ansible module in Python
Ansible is probably the best Configuration Management tool currently available. In its simplest form it is an agentless automation tool…
- Oracle 19c: ASM and SGA_TARGET lead to crashes
Few months ago I’ve found a frustrating issue while I was testing Oracle 19c. We usually set ASM to use…
- Golden Gate: replicator node AVRO/HDFS over a S3 Bucket 4/4
We have an integrated extractor capturing data from our source Oracle database. It store captured data in local trails and…
- Golden Gate: data pump and hub nodes 3/4
You got your database ready and your integrated extractor running. You need some data pump to move your data around.…
- Golden Gate: source node 2/4
Setting up the DB First thing you need a Oracle DB Enterprise Edition 12.1. You need to configure database with…
- Golden Gate: from Oracle Database to S3 bucket/HDFS architecture 1/4
Architecture As stated in previous posts, the whole picture consists in replicating contents from a Oracle DB to a s3bucket…
- Oracle to the power of Python!
Every DBA is doomed to make some scripts and with enough time, they will increase in numbers like thousands if…
- Replication: moving data around in near real-time
In today world, data needs to be moved from one place to another. Usually there are at least two main…
- Oracle, Vagrant and Ansible
A great way to experiment Oracle database directly on your laptop in a controlled manner is by using a virtualization…
- Your friendly custom session browser
Every DBA sooner or later needs to do some session browsing, trying to find out clues about blocking sessions, check execution…