GoldenGate for Big Data 12.3.2.1.1 introduces a new target – Google BigQuery. BigQuery handler can work in two Audit log modes: 1. auditLogMode = true 2. auditLogMode = false I want to review the differences between these two operation modes…
Read More >Creating AWR reports is a common task for many DBAs. At times, you may need to generate multiple AWR reports from multiple databases for performance audit; Ansible allows you to automate these types of tasks. You can, for example, generate…
Read More >There are multiple optimizer features introduced in the Oracle Database 12.2 Release. Bushy Join Trees is the one that I’ll be demonstrating in this post. First, I’ll create four tables with two indexes: create table t1 as select rownum n1,…
Read More >I’ve been making some tests recently with the new Oracle 12.1.0.2 In-Memory option and have been faced with an unexpected performance problem. Here is a test case: Waiting for in-memory segment population: Now let’s make a simple two table join:…
Read More >Recently we’ve seen a strange problem with the deadlocks at the client database on Exadata, Oracle version 11.2.0.4 . Wait events analysis showed that sessions were waiting for “enq: TX – allocate ITL entry” event. It was strange because there…
Read More >