InNAZARbyMatheus Oliveira·Mar 26, 2025AWS RDS com lentidão causada por limitação de Throughput da instância RDSDurante um período de maior demanda em um ambiente crítico de um de nossos clientes, que utiliza AWS RDS com Oracle, a performance degradou…
InNAZARbyMatheus Oliveira·Nov 7, 2023[ SQL Performance Killers] — Individual inserts vs. Bulk inserts.An important part of my daily work is to help developers, database administrators, devops, sysadmins and project managers to identify…
InNAZARbyMatheus Oliveira·Jul 13, 2020Azure Database for PostgreSQL Single Server intermittent restart and recovery due to undocumented…If you are experiencing Azure Database for PostgreSQL intermittent restart and recovery, it may be due to internal Log file reaching 1 GB.
InNAZARbyMatheus Oliveira·Oct 28, 2019Migrating from Oracle RAC to AWS RDS with 15 minutes downtime.A few days ago, we were challenged to reduce the database downtime for an Oracle RAC (on-premisses) migration to AWS RDS. Other teams had…
InNAZARbyMatheus Oliveira·Jan 23, 2019Oracle RDS Read Replica with DMS CDC.Even though Read Replica (RR) feature is not natively available for Amazon RDS for Oracle, you can implement it using Database Migration…
InNAZARbyMatheus Oliveira·Aug 21, 2018[ SQL performance Killers ] — STALE STATISTICSAn important part of my daily work is to help developers, database administrators, devops, sysadmins and project managers to identify…
InNAZARbyMatheus Oliveira·Jul 30, 2018[ SQL performance Killers ] — VIEWSAn important part of my daily work is to help developers, database administrators, devops, sysadmins and project managers to identify…
InNAZARbyMatheus Oliveira·Jul 23, 2018[ SQL performance Killers ] — Implicit ConversionsAn important part of my daily work is to help developers, database administrators, devops, sysadmins and project managers to identify…
InNAZARbyMatheus Oliveira·Jul 13, 2018[ SQL performance Killers ] — IN vs EXISTSAn important part of my daily work is to help developers, database administrators, devops, sysadmins and project managers to identify…