Postgres Covering Indexes and the Visibility Map

Covering indexes in Postgres came up in our weekly tech call because of a query optimization review one of the teams ...

Silent Rollback From an Out-of-Place Patching For Oracle 19c GI

My last post dealt with

OPatchAuto Bug on 19.3 GI/RDBMS When Patching to 19.6

Background

The other day I was doing a fresh install of Oracle 19.3. I ...

Setting up MySQL Monitoring With New Relic Infrastructure Pro

Intro

If you have a New Relic Infrastructure Pro license, and unmonitored MySQL servers, there's now an ...

ProxySQL Query Rules: Notes From Production

Query Statspack's "SQL ordered by" Sections Over a Time Period

In this post, I'll present the

Mining Statspack and AWR Repositories for Historical Trends

There are various ways that we can approach the analysis of a past database performance problem. The initial steps ...

Postgres Security Patches Related to the Search Path

There were some security patches released this month for Postgres, to put further restrictions on pathways that ...

Resolving Error ORA-28353: Failed to Open Wallet

Troubleshooting TDE wallet failures after october 2018 patching

Full ...

PostgreSQL Backups

There are at least four ways to back up a Postgres database: SQL dump, filesystem snapshots, continuous archiving, and ...

Overcoming ORA-01722 Error While Doing an Upgrade With Different DST Versions

This will be a short entry, but hopefully, it will help if you face the error "ORA-01722: ...

Postgres partial indexes on email address domains

When I first heard of Postgres partial indexes, I knew immediately that this would have solved a problem I had in MySQL ...

Using SQLCODE Function

The idea of this post is to show how to handle errors using SQLCODE function. That function shows ...

Silent Out-of-Place Patching For Oracle 19c GI

Troubleshooting OCI automatic backups

I am going through a process of ...

The things I hate about Apache Cassandra

Intro

Migrating SQL Server On-Premise to Azure SQL

Let’s revisit our options when moving your SQL Server workloads to Azure and check out ways to migrate on each of them. ...

19c Auto-Indexing: ORA-65532: Cannot Alter or Drop Automatically Created Indexes

It’s one of those classic "Oracle knows best" moments, isn't it? You try to take back control of your own schema, ...

Migrate Postgres Database from EC2 instance to RDS using AWS DMS (Data Migration Services)

In this post, we will explore one approach to Migrate PostgreSQL DB on EC2 instance to RDS instance using AWS Data ...

Best practice recommendations for Windows hosting SQL server on VMware

Did you know it's very important to ensure that your VMware environment is properly set when hosting SQL Server ...

Cassandra Vulnerability - CVE-2020-13946 - Apache Cassandra RMI Rebind Vulnerability

On September 1, 2020, Apache disclosed a security vulnerability for Apache Cassandra.

Summary:

CreateGoldImage Followup - Is CreateGoldImage Required for Cloning Oracle Home?

Comparing CreateGoldImage and Traditional Tar Cloning

Michael Dinh Published : Aug 24, 2023 Last Updated : Aug 25, 2020 2 min read

Management and Troubleshooting Features: Data Guard Command-Line Interface (DGMGRL) 19c

With Oracle Data Guard promising high availability, data protection and disaster recovery for enterprise data, it's ...

Exadata's InfiniBand Switch: Incorrect NTP settings Leading to Evictions, and Patching Recommendations

Overview

AWS RDS: 5 Must-Know Actions for Oracle DBAs

Managing Oracle on AWS has some twists. Here are five daily DBA activities that have changed on AWS:

How to Fix the Status of the Oracle GI CRS After a Failed Upgrade

Editor's Note: Because our bloggers have lots of useful tips, every now and then we update ...