-
Fixing Replication Lag with Parallel Logical Replication in Aurora PostgreSQL
Our nightly batch job kept freezing a downstream reporting dashboard for several minutes, and it turned out our Aurora PostgreSQL subscription was just waiting for one giant transaction to commit. Here’s how turning on parallel logical replication fixed it.
-
SQL Server 2025 Intelligent Query Processing: What Changed at Compatibility Level 170
Bumping our database to SQL Server 2025’s compatibility level 170 quietly changed how two of our worst-behaved queries got their execution plans. Here is what Parameter Sensitive Plan optimization’s new DML support and Optional Parameter Plan Optimization actually did, and the monitoring query that broke along the way.
-
Priority Transactions: Letting the Database Roll Back Its Own Blockers in Oracle AI Database 26ai
A hung transaction used to mean tracking down the blocker and killing the session by hand. In Oracle AI Database 26ai the database can roll back a lower-priority blocker automatically, and I walk through how to set it up and where it can bite you.
-
Automatic Transaction Quarantine in Oracle AI Database 26ai: When One Bad Transaction Won’t Take Down the Whole Database
One transaction failing to recover used to mean the whole database could go down until Oracle Support helped you skip past it. In Oracle AI Database 26ai, SMON quarantines that one transaction instead, and I walk through monitoring and resolving it.
-
Oracle AI Database 26ai Is a Patch, Not an Upgrade: Reading the New Version Numbers
I was asked to scope a 26ai upgrade project the way we scoped our last major version move. Turns out if you are already on 23ai, it is just a quarterly patch, and I walk through the new version numbering that explains why.
Blog Posts
Hello,
Arvind Toorpu
I am a Database Admin/Architect with over 14+ years of experience managing multiple DBMS systems
Let’s connect
Join the fun!
Stay updated with our latest tutorials and ideas by joining our newsletter.
Recent posts
- August 2026
- July 2026
- August 2025
- July 2025
- June 2025
- May 2025
- April 2025
- March 2025
- February 2025
- January 2025
- December 2024
- November 2024
- September 2024
- August 2024
- July 2024
- June 2024
- May 2024
- April 2024
- March 2024
- February 2024
- January 2024
- August 2023
- June 2023
- May 2023
- May 2022
- November 2021
- August 2021
- April 2021
- January 2021
- March 2020
- November 2019
- February 2019
- December 2018
- June 2018
- June 2017
- April 2015
- March 2015
- February 2015
- January 2015
- November 2014
- October 2014
- September 2014
- August 2014
- July 2014
- June 2014
- May 2014
- April 2014
- March 2014
- February 2014
- December 2013
- November 2013
- October 2013
- September 2013
- August 2013
- July 2013
- June 2013
- May 2013
Arvind Toorpu 