Operations | Monitoring | ITSM | DevOps | Cloud

New in Redgate Monitor: Oracle Data Guard support

Redgate Monitor now supports Oracle Data Guard environments, giving DBAs instant visibility into replication health, lag and role transitions, so Standbys stay in sync and are ready to protect availability and data when needed. DBAs running Oracle Data Guard know that keeping replicas healthy requires constant vigilance. It often involves querying dynamic performance views, such as V$DATAGUARD_STATS, or running Data Guard Broker commands to check lag and role status.

Redgate Monitor Adds Support for Oracle Multitenant

Redgate Monitor now gives you full visibility into activity across Oracle Multitenant environments. With metrics and alerts at both the Container Database (CDB) and Pluggable Database (PDB) level, you can quickly pinpoint performance issues and ensure compliance. With the introduction of Oracle multitenant architecture in Oracle 12c, many teams began consolidating databases into a single Container database (CDB). This helped them to optimize resource usage and simplify patching.

Built for simplicity and scalability: why organizations choose Redgate Flyway

Redgate Flyway is renowned for its low-friction, SQL-first approach. Our customer stories share the wins seen in organizations worldwide for Redgate Flyway. And when it comes to community endorsement for Flyway OSS, the GitHub and Docker statistics prove it, with 9k+ GitHub stars and 50M Docker downloads advocating for its appreciation.

Flyway and Optimized Partition Management for Oracle Databases

I’m pleased to announce that Flyway continues to improve its support for Oracle databases with every release, focusing on performance, reliability, and developer efficiency. The most recent updates to Flyway Desktop and Flyway CLI specifically target a long-standing challenge for Oracle users: unnecessary table rebuilds when migrating to partitions or when managing partitions.

A local fix just spreads the problem

“You fixed a bug in QA — great! But did that fix go into version control and get tested and deployed everywhere? If not, you just created drift, and more problems down the line.” Peter Kruis, Microsoft SQL Engineer at Monin Fixing a bug in the environment where it appears feels like progress, but without a proper process, it creates fragility everywhere else.

Break it early to ship it safely

“We want developers to break things – just not for the customers. If all our tests are green, I get nervous that we’re not testing deep enough.” Naga Santhosh Reddy Vootukuri, Principal Software Eng. Manager, Microsoft Azure SQL Naga Santhosh, Sunny to most, leads a team that ships changes to Azure SQL databases worldwide. Those deployments must be fast, frequent, and invisible to customers. That kind of reliability doesn’t come from playing it safe during development.

PostgreSQL Table partitions now supported in Flyway

This blog post was originally authored by Prajakta Tamhankar, whose insights and expertise shaped much of the content you’ll read here. We are thrilled to announce the General Availability (GA) of Table Partitions for PostgreSQL users in Flyway v8.0.2. This new functionality is designed to enhance your database management experience by providing robust support for table partitions, including sub-partitions and range partitions.

Flyway code analysis - These are a few of my favorite rules

Clean, consistent SQL code isn’t just a preference. It’s a pathway to healthier applications, faster debugging, and happier teams. Whether you’re onboarding new developers or optimizing legacy systems, having a clear set of standards can make all the difference. Flyway’s code analysis is a powerful ally in keeping your database code tidy and secure, and making sure best practices are being followed.